Missing Messages from chat.db

Hi so I can't currently create a minimum reproducible example but I am missing texts that I know I sent and appear in the search on the iMessage app but aren't in chat.db My python code below

import sqlite3
import pandas as pd

db = 'chatCopy.db'
conn = sqlite3.connect(db)
c = conn.cursor()

cmd1 = 'SELECT * \
            FROM message \
            '

c.execute(cmd1)
messages = pd.DataFrame(c.fetchall(), columns = list(map(lambda x: x, c.description)))

messages[messages['text'].apply(lambda x : 'Maybe like Sherlock' in x if x else False)].shape
>>>(0, 68)

Then when searching in iMessage Finally when going to ~/Library/Messages/Archive/ the messages do exist. (This is what I assume the messages app is actually searching.) I have somewhat noticed that this is only happening with older messages although I cannot confirm that this only happens to older messages.