I thought the prevailing advice was to expose views (materialized or not) rather than tables directly, but I could be wrong or outdated. I still probably would

I thought the prevailing advice was to expose views (materialized or not) rather than tables directly, but I could be wrong or outdated. I still probably wouldn’t do it, though. My “lazy” solution is usually OpenAPI code generation so I basically only have to fill in the SQL queries. Not having any code gives me the nagging feeling that very soon I will hit a problem that’s trivial to fix in code but impossible or very stupid to do via a SQL query.