sqlc
sqlc copied to clipboard
sqlc-dev
Generate type-safe code from SQL
### What do you want to change? MariaDB has some extensions over standard MySQL, most notably a UUID type, which currently leads to: ``` internal/datastore/mysql/migrations/schema.sql:4:44: syntax error near "uuid NOT...
### Version 1.22.0 ### What happened? I have to update the query that backs a materialized view. To do this, I create a new temporary materialized view, `view_2`, drop the...
### Version 1.26.0 ### What happened? Parse query file without errors and generate proper structure ### Relevant log output ```shell 2024/05/29 11:55:18 dolphin.convert: Unknown node type *ast.TrimDirectionExpr # package query.sql:2:12:...
### Version 1.26.0 ### What happened? I have query ```sql select title,image,organization_name,organization_logo from filter($1,$2::bigint[],$3,$4); ``` when I generate code sqlc output such message ``` column "title" does not exist ```...
apart from the predefined where clause, it needs somehow to be able to support passing a string containing a filter clause that it's parameters are already resolved prior to the...
### Version 1.26.0 ### What happened? Input: ```sql -- name: Insert :exec INSERT INTO authors (name) VALUES (sqlc.arg(name)) ON CONFLICT (name) DO UPDATE SET data = sqlc.arg(data); ``` Output: ```go...
### Version 1.25.0 ### What happened? I have some table A and I made a LEFT JOIN on table B, but i used the `sqlc.embed(b)` on the table that I...
### Version 1.26.0 ### What happened? Cannot filter and sort on columns from a subselect ### Relevant log output ```shell sqlc generate # package db query.sql:50:7: column "distance" does not...
MySQL, PostgreSQL and SQLite all now have support for JSON values. They also include a large set of JSON functions. sqlc should be able to marshal / unmarshal JSON values...
