sqlc
sqlc copied to clipboard
sqlc-dev
Generate type-safe code from SQL
I had this in a goose sql file ``` -- +goose Up ALTER TABLE providers ADD COLUMN "path" TEXT NOT NULL DEFAULT ''; COMMENT ON COLUMN "providers"."path" IS 'Path relative...
Syntax error is being thrown when there is a column containing colon, which is a valid SQL syntax, for example ``` CREATE TABLE authors ( id BIGSERIAL PRIMARY KEY, name...
The following query is compiled, although it should not, since the `is_deleted` column does not exist. ```sql UPDATE public.articles SET is_deleted = TRUE WHERE id = $1; ``` Schema: ```sql...
These parameters should end up as `interface{}`, not `json.RawMessage`. ```sql CREATE TABLE "user" ( "id" INT PRIMARY KEY GENERATED ALWAYS AS IDENTITY, "metadata" JSONB ) -- name: FindByAddress :one SELECT...
The following query asks to insert to a non-existing field `is_private` yet it compiles without error: ```sql CREATE SCHEMA td4; CREATE TABLE td4.test_codes ( id SERIAL PRIMARY KEY, created_by text...
Input: (PostgreSQL) ```sql -- name: FetchContentLocalization :many SELECT c.id, --- Error here tx1.value AS name, tx2.value AS description, tx3.value AS text1, tx4.value AS text2, tx5.value AS text3, tx6.value AS text4...
### What happened? Hello, I'm trying to generate Go Code from SQL Query using ANY method. When I run `sqlc generate`, variable with array method gets unexpected name. **Actual result:**...
### Version 1.14.0 ### What happened? Actually, NULLIF also smells bad. When using it in a query, the Go struct is generated with a field with a bool type, instead...
### Version 1.10.0 ### What happened? Given the following query: ```sql WITH q AS ( SELECT authors.name, authors.bio FROM authors LEFT JOIN fake ON authors.name = fake.name ) SELECT *...
### Version 1.12.0 ### What happened? While testing python codegen, I found a rather curious output: any table that ends in "**ta**" gets a model that ends in "**tum**" due...
