Hmm...

Right now its generating me code with errors. For example:

-- name: complexQuery :many
select employee_id, name, department_id, salary
from employees
where
    (department_id = ? or ? is null)
    and (salary >= ? or ? is null)
    and (hire_date between ? and ? or (? is null and ? is null))
    and (skills->>? = ? OR ? IS NULL)
ORDER BY
    CASE WHEN ? = 'salary' THEN salary END DESC,
    CASE WHEN ? = 'hire_date' THEN hire_date END DESC
LIMIT ? OFFSET ?;

-- name: getUsersByStatus :many
select * from users
where status = ?;

-- name: insertNewUser :exec
insert into users (name, email, status)
values (?, ?, ?);

-- name: getUsersByIds :many
select * from users
where id in (?, ?, ?);

-- name: getUsersByAgeRange :many
select * from users
where age between ? and ?;

-- name: getLimitedUsers :many
select * from users
LIMIT ? offset ?;

-- name: getGroupsByCount :many
select status, count(*)
from users
group by status
having count(*) > ?;

-- name: orderUsersByColumn :many
select * from users
order by ? asc;

Maybe I am using it the wrong way? Tried to delete the comments in this file too with same result.

typesql_parser maintainer #63

Description

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions