String

✓ functional

Tame casing, truncation, and whitespace so text columns stay useful at a glance.

Text arrives as stored, with no one-size-fits-all defaults pane. When a column needs help, right-click its header and choose Set Formatting Override…. The picker keeps its options in three focused tabs.

Template

Use a {value} placeholder with pipe helpers for casing, truncation, padding, and the other small adjustments that make text easier to read:

Helper	Effect
`upper` / `lower`	Change case.
`trunc:N`	Truncate to N characters, appending an ellipsis.
`prefix:S` / `suffix:S`	Prepend / append literal text.
`pad:N`	Left-pad with spaces to width N.
`default:S`	Substitute S when the value is empty.

-- sqlly format: column=code; template={value|upper}
-- sqlly format: column=notes; template={value|trunc:40}

JSON path

Extract a useful leaf from a JSON text column, such as $.customer.name or $.items[0], and provide a fallback when the path is missing.

Number

Apply numeric styling to any column: fixed, percent (×100 with a % suffix), or bytes (B / KiB / MiB / GiB / TiB), with your chosen decimals and separators.

SQLly per-column string formatter picker dialog — The per-column formatter picker showing the Template, JSON path, and Number tabs.

Related: sensitive text can be redacted with a mask= override, which can also gate exports.