`tracker` is broken after `sqlite` update to`3.45.3`

Description:

tracker3 doesn't add any files to index, this log message is repeated for any attempt to index a file:

tracker-miner-f[54358]: Could not execute sparql: ambiguous column name: ROWID

Additional info:

• package version(s):
  • tracker3 3.7.1-2
  • sqlite 3.45.3-1
• config and/or log files: N/A
• link to upstream bug report, if any:
  • https://gitlab.gnome.org/GNOME/tracker/-/issues/435
  • https://gitlab.gnome.org/GNOME/tracker-miners/-/issues/330 (may be related)

Steps to reproduce:

run

systemctl mask --user --now tracker-miner-fs-3.service 
tracker3 reset --filesystem
systemctl unmask --user --now tracker-miner-fs-3.service

and wait for it to index the files. After some minutes make a check and it will show that no files are indexed:

% tracker3 status | head -n 1
Currently indexed: 0 files, 0 folders

Fix available:

Upstream fix: https://gitlab.gnome.org/GNOME/tracker/-/merge_requests/665

Backporting the patch fixes the issue: files are being indexed again, the error message above disappears.