Connect to a database and verify the connections with a ping.
Exec executes a query without returning any rows.
Get single result or return an error.
Query executes a query that returns rows, typically a SELECT.
Select creates slice of results based on SQL query.