Sorry if I open this issue, @kyleconroy, it is mostly a question but certain words that I will use can be "searched" and anyone can benefit from your answer and the discussion that could follow.

PREAMBLE

I discovered this project a few hours ago.

After trying everything in Go (go-pg, sqlx, sqlboiler, gorm, kallax and others) I believe your project is simply WONDERFUL!

But before jumping into it headlong I would like to understand if I can really achieve what I have in mind.

My project has many tables (around 100 today).

90% of the operations are simple CRUD.

For all tables I have the same (or very similar) .sql file, like this:

-- name: GetPlayer :one
SELECT * FROM players
WHERE id = $1 LIMIT 1;
-- name: ListPlayers :many
SELECT * FROM players
ORDER BY id desc;
-- name: CreatePlayer :one
INSERT INTO players ( account_id, team_id, topology )
VALUES ($1, $2, $3) RETURNING *;
-- name: UpdatePlayer :one
UPDATE players
SET account_id = $2, team_id = $3, topology = $4
WHERE id = $1
RETURNING *;
-- name: DeletePlayer :one
DELETE FROM players
WHERE id = $1 RETURNING *;

And so far so good. Everything works very well (again, congratulations!).

MY REAL FEAR

For this project I also need to create GraphQL APIs.

Almost every table must be able to be filtered on all or some specific columns.

And the goal is to have a dynamic and flexible query like:

export const LIST_PLAYERS = gql`
 query ListPlayers($first: Int, $skip: Int, $orderBy: PlayerOrderByInput) {
 players(first: $first, skip: $skip, orderBy: $orderBy) {
 id
 created_at
 ...
 }
 }
`

or

query {
 products(limit: 5, where: { price: { gt: 12 } }) {
 id
 name
 ...
 }
 purchases(
 limit: 10
 order_by: { created_at: desc }
 where: { user_id: { eq: $user_id } }
 ) {
 id
 created_at
 ...
 }
}

Using also these logical operators: https://supergraph.dev/docs/graphql#logical-operators.

(SuperGraph is an amazing project!)

QUESTION

Is there any way to create such a dynamic query?

I read this issue and got a little scared.

Thanks for your effort and your patience.

If sqlc can solve my problem there will be sponsorship: these gold projects must be financed! 😄