4 ms·
I wrote my own library in Java recently for something similar. It was inspired by LINQ and SQL grammar. Select statement = table1.select() .join(ta
by batbomb 13y ago
I wrote my own library in Java recently for something similar. It was inspired by LINQ and SQL grammar.
Select statement = table1.select()
.join(table2,[join condition])
.where(table1.col1.gt(10))
.groupBy(table1.col1)
.selection(col1, Fn.avg(table1.col2))
Select s = new Select()
.from(table1)
.join(table2, table2.t1_col1.eq(table1.col1))
.where(table1.col1.gt(10))
.groupBy(table1.col1)
.selection(col1, Fn.avg(table1.col2));
- andrewcooke 13y agohave you seen empire db? http://empire-db.apache.org/ http://empire-db.apache.org/ no-one much seems to use it, but it's actually quite neat.