sqlc
sqlc copied to clipboard
sqlc-dev
Generate type-safe code from SQL
Fixes #3350 Fixes #3684 Fixes #3800 In sqlite there is a quirky behavior where backticks are included in table and column names. This causes errors like relation "x" does not...
I want to generate `sql.NullFloat64` but got` interface{}`. How can I get the correct type? Here is my `query.sql` and `schema.sql`. query.sql ```sql -- name: ListTest :many SELECT (a1 /...
### What do you want to change? Support RETURNING statement with :copyfrom Example: ```SQL -- name: CreateSignalsAndReturnUuid :copyfrom INSERT INTO metadata.signals (slug, name, description) VALUES ($1, $2, $3) RETURNING uuid;...
Visiting https://play.sqlc.dev/ shows a blank screen with the message "This service has been suspended."
sqlc should treat PostgreSQL function return values as nullable (e.g. *string) to avoid scan errors
#### 📌 Problem When using `sqlc v1.30.0` with a PostgreSQL function that returns a nullable scalar type like `TEXT`, `sqlc` generates non-pointer types (e.g. `string`), which causes runtime errors when...
### Version 1.30.0 ### What happened? Given the following tables: ```sql create table everflow_admin.customer_contract ( ... `status` enum('active', 'done', 'early_terminated', 'deleted', 'pending') not null, ... ) ``` ```sql create table...
### Version 1.15.0 ### What happened? Rows returned by selecting from a CTE don't have the custom type overrides from the underlying columns. Parameters to the queries in the CTE...
**EDIT:** Sorry, I did not intend to open this PR over here _yet_, it was meant for `coder/sqlc`. But since it's here already. I'll keep it open. --- While adding...
@kyleconroy What do you think of using an external database engine as a plugin, similar to a database/sql or GORM (for example using "_" import for register engine)? _Originally posted...
