Can user directly connect to the database and query it?

Yes, but that option is only supported when VIDIZMO is deployed in private cloud or within corporate network. Shared VIDIZMO instance does not allow querying database. However, access through separate reporting server is recommended.