Column Modifiers
Column modifiers are prefixes you add to a column's alias to change how Kvery
renders that column in the result. They are written as a prefix followed by ::
in the column alias, so the change lives entirely in your SQL — no separate UI
configuration needed.
SELECT
id,
name,
payload AS "json::details",
password AS "hidden::password_hash"
FROM records;
In this example the details column is rendered as formatted JSON and the
password_hash column is hidden from the table.
Available modifiers
| Modifier | What it does |
|---|---|
json:: | Render the column's value as formatted JSON. |
hidden:: | Hide the column from the displayed result (still available internally). |
select:: | Render the column as a select/dropdown input. |
selectable:: | Make the column's cells selectable. |
nosort:: | Disable sorting on the column. |
nosearch:: | Exclude the column from the table's search. |
operations:: | Mark the column as holding row operations/actions. |
simple:: | Render the column in a simplified form. |
long:: | Treat the column as long content. |
long-value:: | Treat the column's value as long (truncated with expand). |
trdata:: | Attach data to the table row (<tr>). |
tddata:: | Attach data to the table cell (<td>). |
tdata:: | Attach table data to the cell. |
How to apply a modifier
Add the modifier as a prefix to the column alias:
SELECT
created_at,
status AS "select::status",
description AS "long-value::description",
internal_flag AS "hidden::internal_flag",
metadata AS "json::metadata"
FROM tickets;
The editor suggests each modifier as an autocomplete item, so you can insert it without remembering the exact spelling.
Common patterns
- Hide helper columns. Select a column you need for logic but do not want to
show, and prefix it with
hidden::. - Pretty-print JSON. Wrap a JSON/text column with
json::so it displays formatted instead of as a raw string. - Truncate long text. Use
long-value::for big text fields so the table stays readable, with an option to expand. - Turn a column into an input. Use
select::to render dropdowns inside the result table.