sqlc

sqlc copied to clipboard

SQLite generation fails when using Quoted Identifiers

1

### Version 1.15.0 ### What happened? Failure when SQLite identifiers are [quoted with double quotes](https://www.sqlite.org/lang_keywords.html), for example quoting a table name as `"test"` or a column name as `"id"` ###...

caleblloyd

Optionally replace sql.Null* types with pointers

1

### What do you want to change? Structs generated by sqlc which contain null fields use the [sql.Null* types](https://pkg.go.dev/database/sql#NullString). However, it would be nice if there was an option to...

xeoncross

### Version 1.15.0 ### What happened? Tried both on v1.15.0 and HEAD (as of August 26 2022). sqlite schema: ```sql -- name: UpdateChild :one CREATE TABLE IF NOT EXISTS Child(...

avalonbits

### What do you want to change? Add support for COLLATE in WHERE clause. Currently if I add `COLLATE NOCASE` after a WHERE expression, it omits the parameter from the...

epes

Support the PostgreSQL engine on Windows

12

Hi, I just started exploring this project. But not able to build the project on windows. Is windows support in the road map. Thanks

dharmjit

### What do you want to change? Add [FTS5](https://www.sqlite.org/fts5.html) support to sqlite engine. schema.sql ```sql CREATE TABLE recipes ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL,...

kkyr

WithTx is not part of the method set of interface generated

11

Hi, I have interface embedding where my db interface is embedding sqlc generated interface. As db interface is then injected to service layer, I am not able to use this....

dharmjit

Timestamp arrays do not scan correctly

2

### Version 1.10.0 ### What happened? When I have a timestamp array in my table and I want to bring the data back, I expect the results to be correctly...

stephanievance29

sqlc ignores model and instead creates inline struct suffixed with Row

3

### Version 1.13.0 ### What happened? `sqlc generate` creates a model in `models.go` like ``` // Code generated by sqlc. DO NOT EDIT. // versions: // sqlc v1.13.0 type QuestionnaireResponseItem...

AndrewRayCode

Parsing intervals fails with `invalid syntax`

2

### Version 1.10.0 ### What happened? Generated code using the `interval` type in Postgres causes `invalid syntax` errors. I've created a sample application to test the behaviour (as I am...

marcusirgens