sqlc gen json

This repository creates a plugin for sqlc that outputs all of the sql query schemas in json.

how it works

There's already a working plugin in the sqlc github repository that generates a json schema. However there is no official release wasm file for that plugin (at least as far as I could find), so I released one here.

All we need to do is clone the sqlc github repository and build the plugin go file with the correct WASM target.

You can find an example of how the generated json looks like here: codegen.json

For more information visit the sqlc docs.

usage

example project

# file: sqlc.yaml
version: "2"
plugins:
  - name: jsonb
    wasm:
      url: https://github.com/daniellionel01/sqlc-gen-json/releases/download/v1.0.0/sqlc-gen-json.wasm
      sha256: 5d48e462aa8db371be5c9ce89a7494ad8e3baf5112e78386091313afd6930061
sql:
  - schema: schema.sql
    queries: query.sql
    engine: mysql
    codegen:
      - out: gen
        plugin: jsonb
        options:
          indent: "  "
          filename: codegen.json