Parameterized query
Place parameters in an SQL query instead of a constant value.
Query parameters
Variables enclosed within double curly braces {{ }} will be interpreted as placeholders for query parameters in SQL.
Replacing fixed values into parameters.
Query snippets
Creating template for your code.
Using ref("template_name")
to reference templates/snippets in your query "template_name" must be in snake_case (no spaces)
Query snippet is best for frequently used logic, and help document common statements and filters like SELECT
function, and WHERE
clauses.
Last updated