how to union two queries with json_build_object?
i would like to union two queries to get a result of type
https://kyse.link/2TBLF
QueryA | QueryB. this query fails the type checker but the generated query seems to work as intended. is there a type hint i can provide somehow?https://kyse.link/2TBLF
Solution
The unioned expressions need to have the same type. You used
When you use different keys, the correct type of the JSON object would be
first_name in the first one an name in the second one. If both have the same property name it works. https://kyse.link/Bc300When you use different keys, the correct type of the JSON object would be
{ name: string | undefined, first_name: string | undefined } but Kysely isn't able to infer it.