gnata-sqlite
End-to-end JSONata 2.x in Go — from SQLite extension to composable React editor
From database to browser
SELECT status, count(*) as orders,
jsonata_query('{
"revenue": $round($sum(total), 2),
"avg": $round($average(total), 2),
"top": $max(total)
}', data) as stats
FROM orders
GROUP BY status
ORDER BY orders DESC;import { JsonataPlayground } from '@gnata-sqlite/react'
function App() {
return (
<JsonataPlayground
expression="$sum(items.price)"
input={jsonData}
theme="dark"
/>
)
}SQLite Extension
Run JSONata expressions inside SQL queries with a streaming query planner. Five purpose-built functions handle evaluation, filtering, and transformation directly in the database.
React Editor Widget
Composable hooks and components for embedding a JSONata editor in any app. Built on CodeMirror 6 with full TypeScript support and zero-config defaults.
145 KB WASM LSP
TinyGo-compiled language server provides diagnostics, autocomplete, and hover docs. Ships as a single .wasm file that runs in any browser or Node.js environment.
Context-Aware Autocomplete
The editor evaluates expressions against live data to suggest nested keys. Completions update as the input document changes -- no schema definitions needed.
The interactive playground running the SQLite extension, WASM LSP, and CodeMirror editor together