convert Record object to json

[python-programmer]

hi, i have a table like this:

Product
    Id
    Name
    Price

And i get a product with this:

async with db.acquire() as connection:
    product = await connection.fetchrow('''
        SELECT id, name, price FROM product WHERE id = 1
    ''')

i want the below result:

{
    'id': 1,
    'name': 'asyncpg',
    'price': 3
}

i want to get a json result from query, and Question is: How do it?

[elprans]

Cast it to a dict: product = dict(connection.fetchrow(...

[mecampbellsoup]

@elprans I am serializing the JSON in Postgres via json_build_object and friends - will this generate another JSON serialization of the data received by the time it reaches asyncpg and I do dict(conn.fetchrow...)?

[Havanero]

cast it to dict is really bad solution what if I want to interact with variables as dot notation without passing it to Pydantic or any other dataclass? We loose the built in hybrid_property technique by doing so. For example.