Page Flow Sqlite Can't Use Identity Of Newly Inserted Item

I am using a page flow and sqlite. I want to insert a record then insert another record referencing the newly inserted item as a foreign key in another record I am adding. I would normal use something like {insertNewDay.identity}. This option doesn’t seem to be there on Sqlite and page flow. If I type it in manually it doesn’t work either. Should this be possible?

As a work around I tried to make a query to find the latest entry. Then use this to. This hasn’t worked either. Could anybody point me in the right direction?

Screenshot 2023-01-12 at 14.55.451996×930 201 KB