Is my query sent anywhere?

No. The converter is qnot running in your browser: parsing, schema inference and conversion all happen on this page, and nothing you paste leaves your browser.

What are startsWith and endsWith in the output?

JsonLogic has no LIKE. qnot writes prefix and suffix matches as startsWith and endsWith operations, as react-querybuilder does; add them to json-logic-js with add_operation if your evaluator lacks them.

Why does it show a schema?

qnot's codecs are typed by a schema. The tool infers a permissive one from your input (numbers, booleans, dates, lists, nested arrays), so you can paste any query. In your app you declare the fields once with defineFields and get the same conversion with exact types.

tools

SQL to JsonLogic converter

Turn a WHERE clause into a JsonLogic rule: the same condition, as JSON you can store and evaluate anywhere.

free
no sign-up
runs in your browser
MIT

input · SQL

output · JsonLogic

{
  "and": [
    { "in": [{ "var": "country" }, ["US", "CA", "GB"]] },
    { "!=": [{ "var": "plan" }, "free"] },
    { ">=": [{ "var": "seats" }, 5] },
    { "startsWith": [{ "var": "company_name" }, "Acme"] },
    { "!": { "and": [{ "==": [{ "var": "beta_opt_out" }, true] }] } }
  ]
}

5 rules · 5 fields · converted Runs in your browser: nothing leaves it.

How it converts

The output follows the conventions react-querybuilder and react-awesome-query-builder use: == and != for equality, in for lists, a three-argument <= for BETWEEN, and startsWith/endsWith/in for LIKE patterns.

JsonLogic compares case-sensitively and coerces null like JavaScript does, so a rule can behave differently from SQL on NULLs and collations. The qnot docs list each difference.

Use it in your app

follows your input and settings

The converter is qnot's codecs. Declare the fields once and the same two calls run on your server or in the browser, typed end to end.

// pnpm add @qnot/core
import { decode, defineFields, encode, f } from '@qnot/core';
import { sqlFormat } from '@qnot/core/formats/sql';
import { jsonlogic } from '@qnot/core/formats/jsonlogic';

// The schema the converter inferred: tighten it (enums, required…) for your app.
const fields = defineFields({
  country: f.text(),
  plan: f.text(),
  seats: f.number(),
  company_name: f.text(),
  beta_opt_out: f.boolean(),
});

const query = decode(sqlFormat({ dialect: 'postgres' }), where, fields);
const logic = encode(jsonlogic, query, fields);

Questions

Is my query sent anywhere?: No. The converter is qnot running in your browser: parsing, schema inference and conversion all happen on this page, and nothing you paste leaves your browser.
What are startsWith and endsWith in the output?: JsonLogic has no LIKE. qnot writes prefix and suffix matches as startsWith and endsWith operations, as react-querybuilder does; add them to json-logic-js with add_operation if your evaluator lacks them.
Why does it show a schema?: qnot's codecs are typed by a schema. The tool infers a permissive one from your input (numbers, booleans, dates, lists, nested arrays), so you can paste any query. In your app you declare the fields once with defineFields and get the same conversion with exact types.

More converters

Every format qnot speaks