Hi HN!
There were an old thread on HN years ago asking people what they prefer, raw SQL or ORM?
https://news.ycombinator.com/item?id=16809620
There were people suggesting "Raw SQL is always better" and people saying "Use an ORM. There's just no reason not to.", as you may expect. However, regardless of the choice you make, you code it in your application with the language you choose for the application, which I think is the root cause for the awkwardness of working with relational database.
Data access service is different. You compose it in its own database-centric environment, and deploy it as a backing service to your application for data access.
More importantly, data access service is standardized, declarative (with SQL and JSON only), aggregate-oriented, transaction-less, tool-driven and cloud-native,
aiming to bring a change to the way and the experience of working with relational database.
If you want to read a bit more about data access service, here is my site:
https://www.backlogic.net/
If you want to try it, here is the link for installing Service Builder, which is the tool for developing data access service, and is a VSCode extension.
https://marketplace.visualstudio.com/items?itemName=BackLogi...
Once you have it installed, open the Getting Started tutorial inside, start a try session with TryWithoutSignup button, and go through the steps of creating query, SQL and CRUD services.
At the moment, it is just a POC. Please take a look, try it and see how you like it or not like it. Your feedback is greatly appreciated either way.
