Don't use table aliases on DELETE

Because old sqlite doesn't support it
matrix-org · babolivier · Nov 25, 2021 · Nov 24, 2021 · Nov 24, 2021 · Nov 24, 2021
commit c294bbb3c777031b1c55bb9c0522b010bd622d1c
@@ -715,14 +715,14 @@ def _remove_devices_from_device_inbox_txn(
             stop = start + batch_size
 
             sql = """
-                DELETE FROM device_inbox AS di
+                DELETE FROM device_inbox
                 WHERE
                     stream_id >= ? AND stream_id < ?
                     AND NOT EXISTS (
-                        SELECT * FROM devices AS d
+                        SELECT * FROM devices d
                         WHERE
-                            d.device_id=di.device_id
-                            AND d.user_id=di.user_id
+                            d.device_id=device_inbox.device_id
+                            AND d.user_id=device_inbox.user_id
                             AND NOT hidden
                     )
                 """