Originally Posted by BetterRed
However if you're determined to use SQL direct, I would suggest you copy the metadata.db file at the root of the library, and use something like DB Browser for SQLite to do queries against it to export CSV, HTML etc. You'll need to spend a few minutes examining the schema but its fairly straightforward.
BR
|