Hi, is there a way to select where some raw query ...

# exposed

[tjohnn]

Hi, is there a way to select where some raw query match? I am looking for something like
E.g Products.select{ whereRaw("where array_to_string('some_psql_array_column') LIKE '%search%'") }
CC @tapac

[tjohnn]

I need it for a postgresql query which I think is not supported out of box

[tjohnn]

Or do I have to completely use raw queries?

[spand]

I think you just need a new function.

[spand]

Take a look at ie. ExpressionAlias and its extension:

fun <T:Expression<*>> T.alias(alias: String) = ExpressionAlias(this, alias)

[tjohnn]

Thanks, can you provide a link on using ExpressionAlias?

[spand]

Look in the source

[tjohnn]

Okay