SQL is good actually. Using your database system to define your data model along with all of its constraints is much better than just scribbling out some Rust/TypeScript/Go datatypes and shitting them out into a schema with a new database migration every fucking commit.
Your SQL application does not need to be portable. You don’t need an over-engineered rube-goldberg solution where you can slot out OracleDB for SQLite for fucking CSV documents. Your code SHOULD be ANSI/ISO standard, but it just needs to run on PostgreSQL. PostgeSQL is portable.
Thanks for coming to my TED talk.
people will build horrible nightmares out of whatever tools you give them, unless they have a fair amount of experience/knowledge and put real effort into planning their data model and queries, which is always going to be a small minority of developers.
But personally I tend to have the same preference, I’d rather keep it simple and directly use the db tools as intended.