Reading the documentation there are some limitations that bothers me, mostly the fact that binary log replication is not supported, but only Full Table and Key Replication. Full Table is hardly an option, and I have a few questions about Key Replication:
What if there's no columns to be used. If for example there's no "updated_at" but only some numeric ID, every update will not be captured. Is Full table the only solution?
The fact that during each sync every row with the replication key greater or equal than the last updated will be imported can cause duplication in the destination? how common is this in your experience? how much work on data cleaning must be done post load?
Do these 2 limitation, in your experience, make stitch a viable option when trying to connect to magento? Or would it be better to develop some custom solution?
