SQLlyFormatting
✓ functionalMake numbers, dates, ids, and text easier to scan without changing the data beneath them.
Formatting helps a result set read like an answer instead of a raw data dump. SQLly starts from the column type, then lets you set defaults or make a deliberate per-column exception. Both paths feed the same formatting model:
- Type defaults. Open Settings › Results to choose how each type appears across SQLly.
- Per-column override. Right-click a header and choose Set Formatting Override…. SQLly writes a
-- sqlly format:directive into the query, so the choice travels with the file.
Numeric and temporal types also share an alignment option (left, center, or right), so it does not need repeating on every page below.
Integer
Grouping, negative style, and K/M/G abbreviation for whole numbers.
Decimal
Precision plus configurable decimal and thousands separators.
Dates
Custom patterns and time-zone handling.
UUIDs
Dashed or compact identifier rendering.
String
Casing, truncation, JSON extraction, and templates - via overrides.
In this section
- Integer — Choose the grouping, sign, and units that make whole numbers quick to read.
- Decimal — Show the precision, rounding, and currency cues that make fractional values make sense.
- Dates — Read dates your way: absolute, relative, or with a format that suits the job.
- UUIDs — Keep long identifiers recognizable without letting them take over the grid.
- String — Tame casing, truncation, and whitespace so text columns stay useful at a glance.