This particular chat messaging database was using BLOBs to store message data. This has often become a good field to investigate, as it is sometimes overlooked, having been thought to only contain large media files.
After looking at several BLOBs from this particular database table, the text always appeared after the values "RAW_CONTENT_VALUE_ONLY_TO_BE_VISIBLE_TO_USER,“ which made the process for finding the content repeatable across a large set of data.