Re:How and why the Relational Model works for databases
by ndm000 on Monday January 17, 2022 @09:53AM
(#29967096)
Reading through these posts, I had exactly the same thought. Why not have a language that takes the problems with SQL and abstracts them to something that is more easily organized into functions, modules, and packages, corrects some of the semantic problems, integrates well with source control, testing, deployment pipelines, etc. DBT is solving this problem well for data warehouses, but I do not know if a similar tool application databases.
Re:How and why the Relational Model works for databases
by tapas73 on Monday January 17, 2022 @09:31AM
(#29966858)
In java world the is https://en.m.wikipedia.org/wiki/Jakarta_Persistence_Query_La...
Is there something similar for SQL, where you allow an alternative syntax and maybe programming approach and then use SQL as connection to the DB ?