Dumb question: how do you write dynamic queries using sqlc? From the doc I see:

    -- name: ListAuthors :many
    SELECT * FROM authors
    ORDER BY name;

But what if I want to get a list of authors by date? Shall I do:

    -- name: ListAuthors :many
    SELECT * FROM authors
    ORDER BY name;
    -- name: ListAuthorsByDate :many
    ...

And what if later I need to get a list of authors by date and name? Should I write yet another query? I'm used to write one generic (composable) query that is very handy in situations where one need to retrieve rows by many different filtering criteria. Is that possible in sqlc?