News for hackers. Stuff that matters.
Re:Easy Steps to a Complete Understanding of SQL by batbomb on Tuesday September 03, 2013 @09:46PM (#6325076)
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));
Re:Easy Steps to a Complete Understanding of SQL by andrewcooke on Tuesday September 17, 2013 @04:00PM (#6401557)
have you seen empire db? http://empire-db.apache.org/ no-one much seems to use it, but it's actually quite neat.