SQL queries for parsing the siriremembers.sqlite3 database found in Apple devices. These queries were formed through original research into this matter, additional testing, and used to parse similar data through various iOS versions. Note, with additional applications changes to the queries may be required.

The siriremembers.sqlite3 database is stored at /private/var/mobile/Library/com.apple.siri.inference/siriremembers.sqlite3

Additional information can be found here: https://metadataperspective.com/2024/01/29/siris-memory-lane-exploring-the-siriremembers-database/