Check my project: https://tablam.org https://tablam.org --- Exist 2 major ways to solve this: You do a transpiler (like most ORM are, actually) or you go dee

Check my project: https://tablam.org https://tablam.org --- Exist 2 major ways to solve this: You do a transpiler (like most ORM are, actually) or you go deeper and fix from the base. The second could yield much better results. It will sound weird at first, but not exist anything that block the idea of "a SQL" language work for make the full app, with UI and all that. SQL as-is is just too limited, in some unfortunate ways even for the use-case of have a restricted language usable for ad-hoc queries, but that is purely incidental. The relational model is much more expressive than array, functional models (because well, it can supersede/integrate both) and with some extra adjustment you can get something like python/ML that could become super-productive.