What is the correct way to execute union from the same querybuilder?

[EMaksymenko]

I need to select several columns from queryBuilder.union(theSameQueryBuilder).orderBy().limit()
As I se there are no UNION support in the library.
What is the simplest way to do it?

[j256]

I don't quite understand. Can you show a short example?

[EMaksymenko]

See my answer suggestion. I think I got it.

[EMaksymenko]

Looks like I found an answer myself. Correct me if I wrong...

val builder1 = dao.queryBuilder() // add some fields, joins and where conditions
val builder2 = dao.queryBuilder() // add another fields, joins and where conditions
val statement = StringBuilder()
    .append(builder1.prepareStatementString())
    .append(" UNION ").append(builder2.prepareStatementString())
    .append(" ORDER BY some_field1, some_field2 LIMIT 10 ")
    .toString()
val resultList = dao.queryRaw(statement, dao.rawRowMapper).use { it.resuts.map { entity -> entity.some_field } }

[j256]

I don't see anything wrong with your answer.

[EMaksymenko]

It requires manual output structure mapping.

I have created CustomQueryBuilder and added union() method there similar to Join.

All other cases did not work.