Created core tests with database interaction
Added test tables
Updated test schema with procedures and functions
Added workaround for executing raw queries directly on the connection object