Merlin (2020)

Need search for key, search sql, apply, delete, reverse, .... ? Reverse would work only if we had a previous statement to run or a previous state to recall. All updates should be full "replace" if possible to make this easier.
2021-08-11 09:42:03L1187406039LISTf_list_open
2021-08-11 09:42:00L1187406039LISTf_list_open27-Jun-22
2021-03-24 11:42:22V1813431028EDITf_ven_add1Oystermouth Road
2021-01-13 12:54:00V1798543557EDITf_ven_typeART
2020-11-20 16:37:16L02071577128LISTf_list_venV765
2020-11-20 16:36:54L02071577128LISTf_list_venV687
2020-11-20 14:37:14L0964642303LISTf_list_venV01754281771
2020-11-20 14:34:42L0964642303LISTf_list_venV0165922284
2020-11-20 14:34:28L0964642303LISTf_list_venV442
2020-11-20 14:34:20L0964642303LISTf_list_venV944
2020-11-20 13:56:32L0825651943venueLISTL0825651943venuethe blakehay
2020-11-20 13:56:10L0825651943LISTf_list_venV01754281771
2020-11-20 13:55:00L0907087873venueLISTL0907087873venueHull New Theatre
2020-11-20 13:54:52L0907087873venueLISTL0907087873venueblake
2020-11-20 13:52:58L0907087873venueLISTL0907087873venuethe
2020-11-20 13:48:53L0907087873venueLISTL0907087873venuethe bla
2020-11-20 13:43:48L0907087873venueLISTL0907087873venue
2020-11-16 17:05:00L0106688191LISTf_list_ph
2020-11-16 17:04:51L0106688191LISTf_list_ph5
2020-11-16 16:36:23L1407757745LISTf_list_to29-Sep-21
2020-11-16 16:36:21L1407757745LISTf_list_to29-Sep-22
2020-11-16 11:33:54L0106688191LISTf_list_to5-Dec-20
2020-11-16 11:33:50L0106688191LISTf_list_to5-Dec-21
2020-10-29 13:54:09L01183751150LISTf_list_when
Action could be EDIT, LIST or SQL (sql in value field) or ADD as we wont have a qtix and can't do any modifications to a record until we have that qtix ... so do we apply all sql first or does an sql trigger immediate processing? so if we get an add the qtix is, e.g., V0, we create a new qtix, update the record and then apply the add?? so the sql for the add needs a dummy that we can replace OR the add is not an sql but a json of the fields/values!