Use of variable with RawSQL - annotating a time delta

Hi,

Does Tortoise ORM provide a safe way to pass my_datetime in to the following query:

class Event(tortoise.models.Model):
    id = tortoise.fields.UUIDField(pk=True)
    scheduled_for = tortoise.fields.DatetimeField(index=True)


my_datetime = datetime.datetime(2022, 10, 20, 11, 30, 30, tz=zoneinfo.ZoneInfo("UTC"))


await models.Event.annotate(
    scheduled_for_delta=tortoise.functions.functions.Abs(
        tortoise.expressions.RawSQL("julianday(scheduled_for) - julianday(my_datetime)")
    )
).order_by('scheduled_for_delta')

I was wanting to get the queryset ordered by the smallest time delta of scheduled_for and my_datetime (i.e. the nearest scheduled event to the provided datetime).

Is there a better way or different approach to do this with TortoiseORM that I haven't found? I'm using sqlite.

Thanks!

Start with the RawSQL expression and annotate query shown in the issue, using SQLite as the target backend. Determine whether Tortoise ORM supports safely supplying my_datetime for this calculation and ordering by the absolute time delta; done means a supported approach is identified or implemented and its behavior is covered.