Other than being able to use Google, I don't know anything about this. However it looks like that sms.db file is a sqlite database. I am pretty sure that many programs on the Mac also use sqlite and when I check, it appears to be installed on my MacBook Pro running Lion as from the terminal I can see it:
[MacBook ~]$ which sqlite3
/usr/bin/sqlite3
[MacBook ~]$
I have installed the developer tools, so it might have shown up when I did that.
It looks like you can get most or all of what you are looking for from a single terminal command line. See:
http://linuxsleuthing.blogspot.com/2010 ... rsing.html