How to add new column to select statement with JSqlParser

Question

This is my sql statement.

String sql = "select mydate from mytable";

How can i add new columns to it dynamically with JSqlParser?

For example i want to add "mylocation" column to my sql query:

String sql = "select mydate, mylocation from mytable";

What is the error that you are getting ? Please add some details to your question — Alpesh Jikadra, Feb 18 '22 at 10:23
i don't get any errors. i am looking for the code to do this since the documentation is lacking and i can't find anywhere how to do this. — Ali Atıl, Feb 18 '22 at 10:29

score 2 · Accepted Answer · answered Feb 18 '22 at 10:38

2

According to the documentation it should work like this:

Select select = (Select) CCJSqlParserUtil.parse("select mydate from mytable");
SelectUtils.addExpression(select, new Column("mylocation"));

answered Feb 18 '22 at 10:38

1 Answers1