Results
Read the answer, shape it for the task, and take it with you when you are done.
A query returning rows is usually the beginning of the work, not the end. The result grid is where you read, reshape, compare, and share the answer. These are the main ways SQLly helps with each result set.
In this section
- Interactive sample in-tab demo
- Try the real result grid in your browser, no installation ceremony required.
- Formatting5 topics
- Make numbers, dates, ids, and text easier to scan without changing the data beneath them.
- Conditional formatting
- Color cells by their values with highlight rules, color scales, and data bars, saved for a column name or written into one query.
- Computed columns
- Add a column worked out with an Excel formula from the result's own columns, with Excel's formula bar, colors, and functions.
- Pivot
- Build a cross-tab by moving fields around, then keep the setup as a reusable directive if you like.
- Chart
- Turn any result set into a chart without leaving the grid - and start from a suggested setup when the decision model is on.
- Map view
- Put Redis GEO replies, longitude/latitude columns, and WKT or WKB shapes on an OpenStreetMap street map you can pan, zoom, and click through to the row.
- Heatmaps
- See where thousands of locations cluster, with an adjustable radius, instead of a pile of overlapping markers.
- Row editor
- Edit, insert, duplicate, and delete rows through a form that understands the table you are in.
- Filtering
- Quick-filter from any cell, pause conditions, type filter expressions with relative dates, and save filters per table.
- Editing tools
- Transform and generate cell values, find and replace across the grid, and copy staged changes as SQL.
- Open in spreadsheet
- Hand a result to Excel, Numbers, or LibreOffice in one click.
- Export
- Send results onward in the format the next person or tool will actually appreciate.
- Excel export
- A workbook that looks like the grid: formats, widths, frozen panes, colors, live formulas, and the pivot on its own sheet.
- Diff two result sets
- Put two result sets side by side and see what changed without doing row-by-row detective work.
- JSON & XML cell viewer
- Open JSON or XML cells as tidy, explorable structures instead of a wall of punctuation.
- Personal-data detection & masking
- Let the decision model flag result columns that look like emails, phones, or card numbers, and mask them in one click.
- Templating language planned
- Describe a transformation once, then let SQLly apply it across the columns that need it.
- Layouts3 topics
- Give multiple result sets the layout that makes the comparison or review easy.
- Query history in progress
- Revisit recent results without rerunning a query just to see what happened last time.