Table of Contents
In addition to the expressions listed in the Ash expressions guide , AshSqlite provides the following expressions
fragment allows you to embed raw sql into the query. Use question marks to interpolate values from the outer expression.
Ash.Query.filter(User, fragment("? IS NOT NULL", first_name))
This wraps the builtin sqlite
Please be aware, these match
not raw text. Use
contains/1 if you want to match text without supporting patterns, i.e
_ have semantic meaning!
Ash.Query.filter(User, like(name, "%obo%")) # name contains obo anywhere in the string, case sensitively