Generate python sql functions with sqlc

config.sqlc.yaml

---
version: "2"
plugins:
  - name: py
    wasm:
      url: https://downloads.sqlc.dev/plugin/sqlc-gen-python_1.0.0.wasm
      sha256: aca83e1f59f8ffdc604774c2f6f9eb321a2b23e07dc83fc12289d25305fa065b
sql:
  - schema: schema.sql # This is the basis for all generated queries
    queries: ../queries.sql # Queries to generate
    engine: postgresql # The engine to use
    codegen:
      - out: ../sqlc/generated # Output directory
        plugin: py
        options:
          package: generated # Python package name
          emit_sync_querier: true
          emit_async_querier: true

sqlc.sh

# Requires sqlc to be installed via brew
# With the config.sqlc.yaml, we leverage the python plugin to create a python version of
# our queries.
sqlc generate -f config.sqlc.yaml