Comment by max76

7 years ago

I would very interested in a language that transcribes to SQL the same way typescript transcribes to javascript.

5 comments

max76

That's more or less what ORMs try to be.

Koshkin 7 years ago

Only in the manner of speaking (i.e. if you conflate 'mapping' with 'transcribing').

If the generated SQL was compatible across a variety of databases and the performance of the SQL was also passable you'd be on to a good thing.

max76 7 years ago

This is a problem I've been thinking about for years. It's possible to write pure ANSI SQL and be compatible across a lot of databases, but to be optimized in different databases it would need to have a target platform to compile to.
I'm really interested in what other developers think about this.

im3w1l 7 years ago

A simple thing would be macros for subqueries

    A := select col_1, col_2, col_3 from table_1
    B := select col_4, col_5, col_6 from table_2 where 2*col_5 > col_4 + col_6
    $A left join $B on table_1.col_1 = table_2.col_5