Automatically add table aliases to "shell" rules
When Migrate generates update rules, it would be VERY useful for it to automatically alias the table, and add that alias to the columns.
See the current shell rule that gets generated:

What I’m proposing is to replace the full table with “s.” and aliasing the column as “s”

It may not seem like much, but in Postgres when there is no visual view designer, it becomes very cumbersome when you have to type out the table names for every column. And I end up repetitively aliasing and swapping in “s.” hundreds of times throughout the rules and reports.
*Similarly, any source report would get “s.” and target report would get “t.”
- And one last thing… can we add “WHERE s.zactive = true” to all update rules? I believe that’s standard methodology?
Log in to comment and vote
Comments1
Kevin McDonald
Apr 8
Hi Jay - Thank you for your feedback — we’ve received it and are actively reviewing it.
Should we need any additional details or clarification, we’ll reach out. We appreciate you taking the time to share your experience and help us improve the product.