it’s in the playlists table, in the “items” column.
[email protected]:~$ sqlite3 /path/to/songs3.db
sqlite> select name, items from playlists;
Library|0
Some playlist|20
Some other playlist|50
— Ron
p.s. if you are using sqlite2, then it’s “sqlite /path/to/songs.db”