Sorry if this was asked previously, tried to find ...
# exposed
e
Sorry if this was asked previously, tried to find but no result. I know that I can execute raw SQL with Exposed, and I also know that currently there’s no support for
UNION
. I need
UNION
in my query, so I was wondering if I could wrap an SQL statement (something like
SELECT 1 AS idx UNION ALL SELECT 2 UNION ALL SELECT 3
) and then I could use this expression to join to another table?
j
@Endre Deak I'm not familiar with a way to wrap raw SQL as an expression. Can you point me at that?
I suppose you could extend
Expression
and override
toQueryBuilder
to do whatever you wanted.