Insert executes the given query.

InsertObjects executes the given query for every object provided.

Select runs a given query.

SelectOne runs a given query with limit 1 agains the given database within a read-only transaction, returning the mapped result or any error that occured.

Update executes the given query.

UpdateObjects executes the given query len(objs) times.

WithReadTx is a convenience wrapper around WithTx, defining the sql-opts as read-only.

WithTx starts a new transaction with ctx as parent context and opts specifying the sql options to use.

WithWriteTx is a convenience wrapper around WithTx.