Insert Raw SQL
Learn how to use specialized SQL functions in queries.
We'll cover the following
The fragment
function
Ecto’s query API gives us nearly everything we need to write even very complex queries. Still, we might have cases where our database exposes some specialized functions that Ecto doesn’t support. The fragment
function gives us an escape hatch for writing bits of raw SQL that get inserted verbatim into the query.
Here, we use the fragment
function so we can call the Postgres lower
function.
Get hands-on with 1200+ tech skills courses.