Raw option for QueryView Templates

[temiComposable]

When editing a QueryView and using a template to reference an input, it lets you add an option after the inputs name -- e.g. {{ input:raw }}. What exactly does this raw setting do, and are there any available options other than raw currently?

[andyvidan]

Understanding raw in QueryView Templates

In Composable QueryViews, inputs can be referenced using template syntax, allowing dynamic values to be inserted into queries.

Literals as Inputs

One common input type is a Literal, which directly inserts a provided value into a query. For example, given a CustomerID Literal input with the template name {{customerId}}, you can reference it in a QueryView like this:

By default, the inserted value is wrapped in quotes:

What Does raw Do?

In some cases, you may want to insert the value without quotes, for instance, when referencing a numeric ID or SQL keyword or table names or column names. To achieve this, you can use the raw option:

{{customerId:raw}}

This results in:

⚠ Warning: Using raw can expose your query to SQL injection risks if user-controlled values are inserted without validation. Use it cautiously!