sqlc

sqlc copied to clipboard

OFFSET computed value causing issue

1

### Version 1.26.0 ### What happened? ```sql ... LIMIT @page_size OFFSET @page_size * @page_number; ``` The multiplication throws the codegen off. Error: `queries/commz.sql:33:3: edited query syntax is invalid: syntax error...

talksik

Can't generate Go code when using `CREATE EVENT ..` in MySQL

1

### Version 1.26.0 ### What happened? Hello! I am working on a side project and I am using [MySQL events](https://dev.mysql.com/doc/refman/8.4/en/create-event.html). The CREATE EVENT statement is a part of my migration...

senicko

### Version 1.26.0 ### What happened? This issue appears to be the same found in #103 Given a table with string column `a` and number column `b`, the following query...

mlucic

Add Ruby support

4

The ruby ecosystem is very much alive, you can see it in [Ruby 2023 ecosystem report by Jetbrains](https://www.jetbrains.com/lp/devecosystem-2023/ruby/ ), and as a developer and an SQLC user, I think the...

doron050

Extra argument added to COALESCE in generated SQLite query causes missing argument error

1

### Version 1.26.0 ### What happened? I'm using SQLite to create the following query: ```sql -- name: GetAllPaginatedForumPosts :many SELECT p.id, p.title, p.content, p.created_at, p.updated_at, p.likes FROM post p WHERE...

buildtheui

syntax error on generated SQL

5

Please go to comment https://github.com/sqlc-dev/sqlc/issues/3457#issuecomment-2199851963 for a more concise reproduction of the bug. ### Version 1.26.0 ### What happened? When calling an UPDATE statement through the generated Golang code, it...

AdrienHorgnies

Override query return type

5

Let's assume that we have two tables (postgres) ```sql CREATE TABLE foo ( id BIGSERIAL NOT NULL, value TEXT NOT NULL; ); CREATE TABLE bar ( id BIGSERIAL NOT NULL,...

reddec

How to reuse return types across queries

4

As I understand it the overrides key in the config yaml is relevent to individual column overrides. What if I have two distinct queries, say `ListSongs` and `SearchSongs`, but they...

kahunacohen

Support joins one to many (is the project still active?)

6

### What do you want to change? I am quite surprised not to see the possibility to generate from a schema that defines a one-to-many relation (considering many people are...

alimoli

Bumps the production-dependencies group with 7 updates in the / directory: | Package | From | To | | --- | --- | --- | | [github.com/antlr4-go/antlr/v4](https://github.com/antlr4-go/antlr) | `4.13.0` |...

dependabot[bot]