[sqlalchemy] Cannot reproduce subquery involving difference of scalar and vector (generate_series)

Hi everyone, I have a database of some `items` which have a range (tsarange => DateTimeRange) column that usually ranges in intervals of a bunch of seconds and I basically want to create an availability statistics of those items (based on their `lower(Item.range)`) for some period (month/day)

[sqlalchemy] Setting entity related object via related attribute (using init_scalar event)

Hi, I am writing a library where I need to hide (for normal usage, since that will be 90% use case) the existence of a Parent object, basically limiting it just to one property and then set the Parent manually within the Child class through this one property. An obvious solution to this would