I try to avoid materialized views when I can due to the problem of keeping them up to date. If I see a materialized view I’d definitely go back to see if I cou

I try to avoid materialized views when I can due to the problem of keeping them up to date. If I see a materialized view I’d definitely go back to see if I could eke out any other optimisation in a straight view rather than use it. With regard to Scenic, I like the way it separates out SQL but I’ve always found how it versions view files with an iteration in the file name a pain. I wish it had the option to just pick up changes in the source file without needing a migration to bump that version number. On larger projects it’s easy to run into version number clashes in different pull requests.