I like SQL but I think it's time for the big players like MySQL, MSSQL, Postgres etc to start using FROM-first and piping syntax. I've had the pleasure of using Kusto query language and it's a huge leap forward in DX.
I feel like a significantly more context-aware autocomplete could go a long way here, most SQL editors are approaching 72% garbage.
It should be possible to make an educated guess at which tables are in play.
Elsewhere I mentioned always fully qualifying entity references which would narrow the list of possibilities down to a more workable number in most cases.
It should be possible to make an educated guess at which tables are in play.
Elsewhere I mentioned always fully qualifying entity references which would narrow the list of possibilities down to a more workable number in most cases.