Ability to use nullable return type

[shagohead]

What do you want to change?

I cannot figure out how to use expressions like these:

SELECT
    (CASE WHEN question_id IS NOT NULL THEN (answer_id IS NOT NULL) ELSE NULL END) answered
...

In these example I want to get boolean only if condition is true, and null if not.

If I do not cast explicit type, I will have an error parse table name: unexpected node type: *ast.Null.
If I cast, I can use only non nullable type.

Maybe you know the way to get this nullable row column?

Thank you!

What database engines need to be changed?

PostgreSQL

What programming language backends need to be changed?

Go

[Spargwy]

Topical.
Same but with time's operations

[vegather]

I often have a similar issue where I know that the result of some operation might be null, but I have no way of letting sqlc know that. (Postgres, Go)