is there the way null constant selection in expose...

# exposed

[윤동환]

is there the way null constant selection in exposed sql dsl?

SELECT 
    m.id,
    m.status,
    m.reservation_no,
    NULL as member_type_detail
FROM member m

Using union all, i have to manny cases to use null as ‘alias name’

[Chantal Loncle]

Currently, it seems the only way to get that generated SQL is to do something like this:

val m = Member.alias("m")
val detail = Op.nullOp<String>().alias("member_type_detail")
            
m.slice(m[Member.id], m[Member.status], m[Member.reservationNo], detail).selectAll()
// SELECT "m".id, "m".status, "m".reservation_no, NULL member_type_detail FROM "member" "m"

Is your question specifically about performing a union between tables with a mismatched number of columns?

If so, Exposed does not automatically generate these filler columns at the moment, but please consider submitting a feature request on YouTrack, if you'd like it to be investigated further.