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.