sqlc

sqlc copied to clipboard

Field order changed in sqlc v1.27 breaking sqlc-gen-python

2

### Version 1.27.0 ### What happened? In Python the generated code requires to be ordered in a certain way (fields with defaults at the end). This was taken care by...

kevinvalk

### Version 1.26.0 ### What happened? ```sql JOIN LATERAL ( SELECT ordinality AS ord FROM jsonb_array_elements_text(p.variants) WITH ORDINALITY WHERE value = v.id::text ) idx ON true ``` get_multiple_products.sql:99:21: column "ordinality"...

blanc42

### Version 1.27.0 ### What happened? While writing a migration which made use of a temporary table, I observed a limitation/quirk of sqlc. The exact migration involves a lot of...

dmjb

Cassandra(or ScyllaDB) support

3

### What do you want to change? We plan to migrate some Postgres workload to ScyllaDB in the next months due to scaling and cost reasons. We heavily use sqlc...

rpstw

Overridden type works for ARRAY of objects but not for a single object

2

### Version 1.27.0 ### What happened? Have a simple ddl for an object in postgres. It uses a TYPE both as an ARRAY and also as a simple object. The...

kayshav

Update table with select causes ambiguous column error

1

### Version 1.26.0 ### What happened? First time I tried field name "id" in both table, it's very common in realworld, but it said "id" is ambiguous, so I change...

cytown

BETWEEN keyword in CTE generates duplicate params

1

### Version 1.23.0 ### What happened? I have a query using a CTE with a WHERE clause filtering a date range using BETWEEN, and sqlc generated the params struct with...

penmanglewood

fix(sqlite): allow using fts5 table name in the where clause

11

Fixes: https://github.com/sqlc-dev/sqlc/issues/3204 Allow using table name to the left of MATCH or equality operator. Related: - https://github.com/sqlc-dev/sqlc/issues/1797 - https://github.com/sqlc-dev/sqlc/pull/2531

naspeh

PRAGMA queries are not recognised

7

### Version 1.25.0 ### What happened? SQLite requires a `PRAGMA` query to enable foreign key constraints. Unfortunately, sqlc does not seem to recognise `PRAGMA` as a valid query, and actually...

sybrenstuvel

### Version 1.26.0 ### What happened? When a query specifies all columns, the generated function should return the struct from models.go. However, if the column order from the query is...

meblum