@var1, @var2 vs $1, $2

Question

swuecho opened this issue 2 years ago · 2 comments

I am trying to auto generated F# code with a custom sqlc plugin.

The sql in sqlc use $1 as placeholder. https://play.sqlc.dev/

let getJwtSecret = """-- name: GetJwtSecret :one
SELECT id, name, secret, audience FROM jwt_secrets WHERE name = $1
""";

in npgsql.Fsharp @var is required. Is it possible to use $1 style placeholder?

let getJwtSecret = """-- name: GetJwtSecret :one
SELECT id, name, secret, audience FROM jwt_secrets WHERE name = @name
""";

Answer 1 · 2023-05-04T11:43:19.000Z

sill WIP.

Answer 2 · 2023-05-05T03:13:16.000Z