sqlc

sqlc copied to clipboard

Fixes https://github.com/sqlc-dev/sqlc/issues/2905

darkfeline

Support composite types

3

### `CREATE TYPE` ```sql CREATE TYPE myarg as ( id integer, name text ); -- name: BasicQuery :one select $1::myarg; ``` ### Automatic table types https://www.postgresql.org/docs/current/rowtypes.html > Whenever you create...

kyleconroy

case expression returns interface{}

4

### Version 1.23.0 ### What happened? When I run `sqlc generate`, it generates interface{} for my custom select fields. I couldn't find how to define type for this fields. Is...

araufdogan

Jille

### What do you want to change? Neither `database/sql` or https://github.com/go-sql-driver/mysql supports nullable unsigned integers. It is easy to define a custom type for them however, so I'd like to...

Jille

Named parameters not recognized without space before @ char

1

### Version 1.25.0 ### What happened? When using named parameters such as `@name`, sqlc doesn't recognize the parameter if there's no space before the `@` character. The generated code looks...

dubek

Am I missing how to model one to many relationships with sqlc.embed?

4

### What do you want to change? Given this query: ```sql -- name: CategoryGetAllAndChildren :many SELECT swipe_category.*, sqlc.embed(swipe_sub_category) FROM swipe_category LEFT JOIN swipe_sub_category on swipe_category.swipe_category_id = swipe_sub_category.swipe_category_id WHERE swipe_category.organization_id =...

austincollinpena

Support additional query types

1

sqlc only supports a few query types: SELECT, UPDATE, INSERT, DELETE. It should be able to support any DDL or DML query.

kyleconroy

Can't run CREATE TEMPORARY TABLE queries with sqlc.

2

### Version 1.13.0 ### What happened? All DDL statements in queries.sql are parsed as schema definition, rather than as queries that can be executed at runtime. I want to create...

Jille

Propose add prepare query for single query

1

### What do you want to change? Currently, the Prepare SQL Statement Function is being set up with all SQL statements. In sql, there are statements I want to set...

tran-the-lam