How can I log sql queries in the SqlModel?

Question

How could I see/log queries sent by sqlmodel to database.

Answer 1

Since sqlmodel uses Sqlalchemy as backend ORM engine, we can use Sqlalchemy logging answer like answer here:

import logging
logging.basicConfig()
logger = logging.getLogger('sqlalchemy.engine')
logger.setLevel(logging.DEBUG)
# run sqlmodel code after this

You should be able to see sql queries in the console.