Is there any way to coerce an expression in an sql...

# squarelibraries

[phldavies]

Is there any way to coerce an expression in an sqldelight .sq query to work around lacking support (for example we're attempting to check containment of an array column with :item = ANY(array_col) or ARRAY[:item] <@ array_col but neither currently seems possible)

[phldavies]

It would be really useful to be able to say "`:item` is TEXT AS MyType" and "`ARRAY[:item] <@ array_col` is boolean" and let the rest of SQLDelight do it's magic and generate a function with item: MyType as parameter, correctly fed into the expression as-is.