We now have all our .sync files in git. There are some great code review features for sql, both human and AI, but we are unable to utlilise because the sql is encrypted. The sql encryption is a relative recent feature ie within about the last 12 months.
The ask is to not encrypt the SQL in .sync files, or at least provide an option to not encrypt or some alternative.
Reason to not encrypt the sql
1/ In git, the reviewer cannot see the before and after change without downloading the branches and opening in Phocassysnc.exe. Slows the process.
2/ We cannot apply any AI smarts to auto review eg catch poor formatting/styling or silly mistakes
3/ Change management is slowed for the same reason as point 1.
4/ There is no sensitive data in SQL, in the connection string yes but that is ok.