public function getTables()
{
$tables = [];
foreach ($this->connection->query('SELECT * FROM cat') as $row) {
if ($row[1] === 'TABLE' || $row[1] === 'VIEW') {
$tables[] = ['name' => $row[0], 'view' => $row[1] === 'VIEW'];
}
}
return $tables;
}