3 ms·
I've always wondered if a newer language could be designed with ANSI SQL as a transpilation target, or each of the vendor SQLs as targets. Optimization of queri
by moron4hire 6y ago
I've always wondered if a newer language could be designed with ANSI SQL as a transpilation target, or each of the vendor SQLs as targets. Optimization of queries would be a huge problem, but it always seemed like the only way it would be possible to break out of the SQL hegemony, i.e. first transpile, then start developing native support in the open source databases, then pressure the proprietary databases to adopt native support.
- throw_m239339 6y agoThat's what frameworks like Hibernate or Doctrine do, they have their own object oriented query language that compiles to SQL.
- moron4hire 6y agoWell, that's an object oriented design, and it's not really a full language in that it has its own syntax. I'm talking about a relational language with its own syntax.
- throw_m239339 6y ago> and it's not really a full language Both DQL and HQL are complete query languages.