Can I directly convert query results to orjson?

[jet10000]

Can I directly convert query result records with foreign key to orjson? I don't want to use postgres's json_row or json_agg

https://github.com/ijl/orjson

[connebs]

asyncpg returns Record objects, which cannot be directly dumped by orjson.

You'll need to convert the Records to python dicts, then dump them with orjson.

That being said, I would maybe rethink why you don't want to use Postgres' built-in JSON functions, if you want JSON in the end anyway.