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?

Please authenticate to join the conversation.

Upvoters
Status

In Review

Board

Syniti Knowledge Platform

Tags

Migrate

Date

About 21 hours ago

Author

jay.hornback@syniti.com

Subscribe to post

Get notified by email when there are changes.