sqlc

sqlc copied to clipboard

feat: add "use_interface_return_types" option

1

- Add the option "**use_interface_return_types**" to direct sqlc generation to use the querier interface for the return type of the WithTx method on the Queries struct. - Include `WithTx` in...

Jesse0Michael

SQLite: Add support for WHERE clause on the FTS5 Table Name

1

### What do you want to change? SQLite supports WHERE clause directly over the Table name to query all the columns. ```sql CREATE VIRTUAL TABLE IF NOT EXISTS ft USING...

ankitrgadiya

Support `sql.Null`

2

### What do you want to change? Go 1.22 includes a generic [Null](https://pkg.go.dev/database/sql@master#Null) type. ```go type Null[T [any](https://pkg.go.dev/builtin#any)] struct { V T Valid [bool](https://pkg.go.dev/builtin#bool) } ``` Null represents a value...

kyleconroy

Generation of required params struct is missing for CopyFrom query when using query_parameter_limit

2

### Version 1.25.0 ### What happened? sqlc is not generating the params struct necessary for a copy-from query when your configuration specifies `query_parameter_limit`. This is on version 1.25.0. Works fine...

renier

SQLite: error parsing schema with `UNIQUE`

1

### Version 1.25.0 ### What happened? I'm trying to generate code for an existing SQLite database. The `schema.sql` file was generated simply by asking SQLite for the schema: ``` echo...

sybrenstuvel

### What do you want to change? It would be really amazing if we can somehow define json tag for embedded structs when use `sqlc.embed` Currently when you have a...

lcnlvrz

Improve "Using transactions" documentation

1

## Overview I was trying to implement a simple transaction following the [documentation](https://docs.sqlc.dev/en/stable/howto/transactions.html) but it's not clear and the code return errors. ## Details to reproduce Files: ``` ├── dbsqlc...

bbonagura9

Named parameters shortcut not working for mysql

2

### Version 1.25.0 ### What happened? Trying to use the @ operator as a shortcut to sqlc.arg, but it does not work when engine is mysql. The parameter is incorrectly...

meblum

Can't override 'bigint' to be uint32

2

### Version Other ### What happened? I am writing a service which can receive uint32 values that it has to persist in a postgres database. I am using sqlc to...

EasyEesteren

`DELETE USING RETURNING` syntax error at or near ","

3

### Version 1.25.0 ### What happened? Fails to generate - `syntax error at or near ","`. This appears to be due to having multiple items in the `RETURNING` clause given...

thomm-o