sqlc

sqlc copied to clipboard

Fix MySQL Mathematical Expression Type Inference

1

This implements type inference for MySQL mathematical expressions. Before this change, queries with arithmetic operations would generate `interface{}` types, which meant no compile-time type safety. Now the compiler properly infers...

rubensantoniorosa2704

FR: Support batching different queries together

1

### What do you want to change? ## Context https://github.com/sqlc-dev/sqlc/issues/1275 was resolved by adding `:batchexec`, `:batchone`, and `:batchmany` commands generating code for submitting multiple instances of the same query in...

jgiles

Support MariaDB default values for timestamp

1

### What do you want to change? If I create a table like for example: ```SQL CREATE TABLE IF NOT EXISTS `session` ( `id` INT NOT NULL, `expiry` TIMESTAMP NOT...

critrun

### What do you want to change? Consider the following sqlc config: ```yaml version: "2" sql: - schema: "migrations/*.sql" queries: - "db/schema1-queries.sql" engine: "postgresql" gen: go: package: "schema1" out: "db/schema1"...

mneverov

### What do you want to change? When I write this query ```sql -- name: Update :one UPDATE "user" SET firstname = $2, surname = $3 WHERE id = $1...

gebes

Optional WHERE parameters via $1 IS NULL OR - redeclared in this block - query_parameter_limit

2

### Version 1.30.0 ### What happened? Fail to generate go gode when using named argument >1 for optional SELECT WHERE query case see https://github.com/sqlc-dev/sqlc/issues/200 suggested solution does not work in...

sergeishilkocardmarket

### Version 1.30.0 ### What happened? Given the following override definition: ```yaml ... go: package: "somepackage" ... - column: "table.column" go_type: "github.com/import/from/within/the/module/somepackage/SomeType" ``` Where the column is of type TEXT,...

urandom

SQLite engine not supporting $AAA params

3

### Version 1.29.0 ### What happened? If I use `$AAA` parameters with SQLite I will get an error but this is supported by the engine as said on SQLite [SQL...

luigiMinardi

Support automatically appending ,string to JSON tags for numeric types (e.g. BIGINT → int64 with json:",string")

2

### 💡 **Summary** Currently, sqlc does not provide a way to globally append `,string` to JSON tags for numeric types like `BIGINT` while preserving the Go type as `int64`. This...

LuoShenKui

`rowid` doesn't work with SQLite FTS5 tables

1

### Version 1.28.0 ### What happened? When creating a virtual table like so: ```sql CREATE VIRTUAL TABLE my_fts USING fts5 ( name, description, content = '', contentless_delete = 1, tokenize...

ajeetdsouza