Are there Java classes for manipulating SQL statements?
For example, break this statement
SELECT col1, col2 FROM table WHERE a = 1 AND b = 2 ORDER BY 1;
into some kind of map.
['select' => {'col1', 'col2'}, 'from' => {'table'}, 'where' => ..]
Then, you would be able to say add to the where clause or add tables to select from. Is this possible?
Best Answer
This may help: zql