v0.4.4

Warning

Every Release before v1.0.0, including this one is an early alpha release. These versions are only released for interested people who want to test this plugin and help make it better.

v0.4.4 - 2025-05-30

Changed

• #112 Improved :execrows performance for asyncpg and added speedup option for :execrows (rayakame)

Fixed

• #112 Added columns kwarg to :copyfrom for asyncpg to fix inserts for columns with default values (rayakame)

plugins:
  - name: python
    wasm:
      url: https://github.com/rayakame/sqlc-gen-better-python/releases/download/v0.4.4/sqlc-gen-better-python.wasm
      sha256: b0d544244edd80dfd4c768c23c133ae7e3a00d03978e33efa5ddaa55ea2845e0

v0.4.3

Warning

Every Release before v1.0.0, including this one is an early alpha release. These versions are only released for interested people who want to test this plugin and help make it better.

v0.4.3 - 2025-05-28

Fixed

• #109 Fixed missing model import when using :copyfrom cmd. (rayakame)

plugins:
  - name: python
    wasm:
      url: https://github.com/rayakame/sqlc-gen-better-python/releases/download/v0.4.3/sqlc-gen-better-python.wasm
      sha256: c178ef76085ab4737a9a83f1147662ff0a9a24b8513405880fdfcde3ad30ca66

v0.4.2

Warning

Every Release before v1.0.0, including this one is an early alpha release. These versions are only released for interested people who want to test this plugin and help make it better.

v0.4.2 - 2025-05-25

Added

• #104 Enabled ruff preview config option. (rayakame)
• #105 Added support for type overrides, allowing users to specify their own python types for specific sql types. (rayakame)

plugins:
  - name: python
    wasm:
      url: https://github.com/rayakame/sqlc-gen-better-python/releases/download/v0.4.2/sqlc-gen-better-python.wasm
      sha256: 9db2bada2a5f30dc0a48047e026d25e08dc169315df4c4836e7900a1f1eb85e6

v0.4.1

Warning

Every Release before v1.0.0, including this one is an early alpha release. These versions are only released for interested people who want to test this plugin and help make it better.

v0.4.1 - 2025-05-23

Fixed

• #97 Added None to QueryResultsArgsType (rayakame)
  Thanks to @null-domain for finding this issue!

plugins:
  - name: python
    wasm:
      url: https://github.com/rayakame/sqlc-gen-better-python/releases/download/v0.4.1/sqlc-gen-better-python.wasm
      sha256: 4e01958114e2fb577782d94dc81556ef43aa3c7d8e1aa3f7ba31e781c443f731

v0.4.0

Warning

Every Release before v1.0.0, including this one is an early alpha release. These versions are only released for interested people who want to test this plugin and help make it better.

v0.4.0 - 2025-05-21

Added

• #59 Added hyperlink to github profile of contributors in the changelog (rayakame)
• #63 Added strict output tests & ci to prevent bugs from happening (rayakame)
• #66 Added an example sqlc.yaml to README.md (AlexanderHOtt)
• #69 Added config option to auto generate docstrings for generated python code. (rayakame)
• #74 Added support for query annotations execrows and execresult for driver asyncpg (rayakame)
• #75 Code coverage tooling (rayakame)
• #74 Added ConnectionLike instead of asyncpg.Connection which allows also using connection pools (AlexanderHott)
• #82 Added tests for aiosqlite driver with 100% coverage (rayakame)
• #86 Added tests for sqlite3 driver with 100% coverage (rayakame)
• #86 Brought sqlite3 back to full compatibility (rayakame)
• #87 Added support for :copyfrom for driver asyncpg (rayakame)

Deprecated

• #63 Added id to reserved keywords so that it will appear as id_ (rayakame)

Changed

• #63 Removed unnecessary msgspec.field() and attrs.field() for models. (rayakame)
• #74 :many queries now return QueryResults allowing both iteration over rows and fetching rows. (rayakame)

Fixed

• #70 Fixed the uv sync command in CONTRIBUTING.md and added an example docker command to create a postgres instance for testing. (AlexanderHOtt)
• #82 Brought aiosqlite back to full compatibility (rayakame)
• #82 Fixed incorrect typing of query function arguments for nullable fields. (null-domain)

plugins:
  - name: python
    wasm:
      url: https://github.com/rayakame/sqlc-gen-better-python/releases/download/v0.4.0/sqlc-gen-better-python.wasm
      sha256: 4abc65163287f21bbb10325f7ba0b2f5aefd13e316e59af06e9b5d73c83ca4b5

v0.3.1

Warning

Every Release before v1.0.0, including this one is an early alpha release. Currently, there is 0% test coverage and these versions are only released for interested people who want to test this plugin and help make it better.

v0.3.1 - 2025-05-07

Fixed

• #50 Fixed missing __init__ return type annotation and connection parameter type when using asyncpg driver. (tandemdude)
• #53 Wrong deserialization of datetime.datetime when using asyncpg (rayakame)
• #53 Fixed unnecessary type conversion when returning data from queries using asyncpg (rayakame)

plugins:
  - name: python
    wasm:
      url: https://github.com/rayakame/sqlc-gen-better-python/releases/download/v0.3.1/sqlc-gen-better-python.wasm
      sha256: 6e2a6d4d4a2320e32ebc25bf718342d97d2de75fc6fd00bf196ca3e5edca6ee8

v0.3.0

Warning

Every Release before v1.0.0, including this one is an early alpha release. Currently, there is 0% test coverage and these versions are only released for interested people who want to test this plugin and help make it better.

v0.3.0 - 2025-05-05

Added

• #37 Added debug config option to enable debug output. (rayakame)
• #38 Added documentation for every configuration option in the README. (rayakame)
• #39 Added emit_init_file configuration option to control __init__.py creation. (rayakame)
• #40 Added support for msgspec model type. (rayakame)

Fixed

• #41 Fixed missing empty lines when using asyncpg driver. (rayakame)

plugins:
  - name: python
    wasm:
      url: https://github.com/rayakame/sqlc-gen-better-python/releases/download/v0.3.0/sqlc-gen-better-python.wasm
      sha256: 4808c257bbdd0acb6c57032f9dae2db7aa3fc464f2bf87f3d27895c4e3556a90

v0.2.0

Warning

Every Release before v1.0.0, including this one is an early alpha release. Currently, there is 0% tests coverage and these versions are only released for interested people who want to test this plugin and help make it better.

v0.2.0 - 2025-05-05

Added

• #29 Added early driver support for asyncpg. Only has support for exec, many and one (rayakame)

Fixed

• #31 Missing return statements for :execresult, :execrows and :execlastid for aiosqlite and sqlite3 (rayakame)

plugins:
  - name: python
    wasm:
      url: https://github.com/rayakame/sqlc-gen-better-python/releases/download/v0.2.0/sqlc-gen-better-python.wasm
      sha256: 777dd5044cd30554740b48eeca07bb4ef1c37306c63dda6235f352376d35c3af

v0.1.0

v0.1.0 - 2025-04-01

Added

• #17 Added support for driver sqlite3 (rayakame)
• #21 Added support for sqlc.embed() (rayakame)

Changed

• #20 Query functions now don't take param-structs (rayakame)

plugins:
  - name: python
    wasm:
      url: https://github.com/rayakame/sqlc-gen-better-python/releases/download/v0.1.0/sqlc-gen-better-python.wasm
      sha256: 7565eaf91222d3c90de2b6ec15180fd15a494783d8be4ef40a1c5c120e1fa07a

v0.0.1

plugins:
  - name: python
    wasm:
      url: https://github.com/rayakame/sqlc-gen-better-python/releases/download/v0.0.1/sqlc-gen-better-python.wasm
      sha256: 013a5f6ac81736e25f2ef713564eb71157054fc49b0b246ebe823c2f1be06d85