Whenever I query a column representing a timestamp with timezone data, it returns a UTC datetime. Even when I update the timezone of the session with SET TIMEZONE <>, the output remains in UTC. I have a scenario in my FastAPI application where I need to dynamically change the timezone of the session based on the end user’s location. I use postgreSQL as my database.

I’m working with a PostgreSQL database using SQLAlchemy in fastAPI, and I need to filter results based on a value in a JSON array column. However, I’m encountering an issue where the filter does not work as expected.

I have made modular architecture in fast api and getting error as shown

I have this scenario for everyone to ponder upon. I have a database manager which creates an engine and provides a session when needed.

I am following the fastapi course from freecodecamp(https://www.youtube.com/watch?v=0sOvCWFmrtA). I am trying to join 2 tables, Vote and Post. The model for vote:-