fix: improve SQLite error handling in metadata.py

[ajithhraj]

metadata.py has two problems:

Uses broad except Exception instead of sqlite3.Error
Uses print() instead of logging for error reporting
db_create_metadata_table has no exception handling at all

I'd like to fix this. Assigning myself.

[github-actions]

👋 Thanks for opening this issue! The maintainers will review it shortly. Till then, do not open any PR. This is a strict rule we like to follow around here :)