It would be great if there was a compiler that would check your SQL queries against the schema, and you could even refactor a column name to update both the schema and the queries.
Data schema changes are difficult, almost regardless of technology - it's been an issue for me from relational dbs to OpenAPIs. gRPC is easier as long as you obey the migration rules, but those impose tight restrictions on what you can change
By the time you really needs to change your database, updating your queries will be the easiest part, compared to reviewing the semantic changes and the data migration.
I’ve experienced what you’ve mentioned before, ORM or not you have issues if you’re shuffling the schema around.
Cool.
It would be great if there was a compiler that would check your SQL queries against the schema, and you could even refactor a column name to update both the schema and the queries.
Microsoft SSDT (SQL Server Data Tools), but I think it only works against Microsoft SQL Server
https://learn.microsoft.com/en-us/sql/ssdt/sql-server-data-t...
Data schema changes are difficult, almost regardless of technology - it's been an issue for me from relational dbs to OpenAPIs. gRPC is easier as long as you obey the migration rules, but those impose tight restrictions on what you can change
By the time you really needs to change your database, updating your queries will be the easiest part, compared to reviewing the semantic changes and the data migration.