java - How to add "WITH" clause to SELECT query with sqlbuilder

Question

I am using Java and SQLBuilder from healthmarketscience.sqlbuilder and I am trying to add WITH clause to my SELECT query dynamiclly.

My current query build with:

selectQuery.addJoins(SelectQuery.JoinType.LEFT_OUTER, Table.joinToQuery);

The expected result should be:

LEFT OUTER JOIN Table WITH(table_convert_subselect=1) ON (...)

标签： javasinglestoresqlbuilder