Can confirm. Shameless plug: I wrote a script to extract the pertinent information from the SQLite database into an HTML page a while back: https://github.com/kccqzy/imessage-db-extract/blob/master/im... It's open source abandonware though. Lost interest in keeping up with the schema updates because I no longer use iMessage.
That's an undocumented implementation detail. It might change without warning at any time. Are you seriously recommending this as a solution for users who want to be able to read past messages?
I’d imagine it’d be difficult for Apple to migrate to anything substantially different as it’d require rewriting a potentially multi GB file, the space for which many users would not have. It’s effectively a massive, distributed, database migration.
https://spin.atomicobject.com/2020/05/22/search-imessage-sql...