How to export links (url's) or other data from specific iPhone chat?

I recently learned how to use sqlite3 in the command line to export a .csv of url's from my icloud_tabs.db I would like to do something similar with a specific iPhone chat. I use Messages as storage for links, quotes, documents, and other data while I work. So I have a chat with myself where I send myself these notes. I would like to use the terminal to export all of this data from this one specific Messages chat (as far back as possible). Even better if I can get more granular and export just url's, or just images of a certain file type, or just PDFs (etc.) Any insight is much appreciated, ty!