How (specificially) do I read a chat.db file?

Like everyone else who uses Apple's Messages app, I have a chat.db file. I'd like to read the file but nothing seems to yeild the expected results. Here is what I've tried so far: - The CLI approach of cd to

~/Libray/Messages

followed by

chat.db

was amongst the best in that something was found and there was an attempt to open the file. Unfortunately, it didn't work as hoped. - Since I now had the db browser for SQLite open, I tried to open the file via that app's gui but because the folder is hidden one, it didn't show. Has anyone had any success with this? I certainly can't be the first person to have tried and I've seen elsewhere the schema may also be an issue.