[sqlalchemy] Re: Calculate rank of single row using subquery

2021-09-14 Thread 'Jonathan Vanasco' via sqlalchemy
> Is this the most efficient way to do this, or am I over-complicating it? That roughly looks like code that I've implemented in the past. If it works and you don't have issues, I wouldn't worry about efficiency. Stuff like this will often vary based on the underlying table data - the structur

[sqlalchemy] Re: AsyncEngine always returns UTC time for datetime column

2021-09-14 Thread 'Jonathan Vanasco' via sqlalchemy
Can you share the database drivers / dialects you use? The discrepancy could be there. On Tuesday, September 14, 2021 at 7:03:27 AM UTC-4 ivan.ran...@themeanalytics.com wrote: > Hi all, > > I am trying to figure it out why AsyncEngine always returns UTC time for > datetime column, any help is

[sqlalchemy] AsyncEngine always returns UTC time for datetime column

2021-09-14 Thread Ivan Randjelovic
Hi all, I am trying to figure it out why AsyncEngine always returns UTC time for datetime column, any help is appreciated? I am working with sqlalchemy core and async engine. Column definition: *Column('test', DateTime(timezone=True), nullable=False)* Also tried with this, but no luck: *_conne