Help with sql query

[eluser]ivantcholakov[/eluser]
In CI3 limitations of the query builder are less, it is improved. For quite complex cases (UNION clause for example) the method get_compiled_select() helps for SQL generation of the sub-queries, so you again can rely on automatic escaping and SOL-dialect abstraction.