DbSimple для работы с MySQL – подскажите альтернативу?

$mysqli = new mysqli('localhost', 'username', 'password', 'database');
 
// Простой селект
$stmt = $mysqli->stmt_init();
$query = 'SELECT * FROM users WHERE chmod = ? AND city = ?';
$stmt->prepare($query);
$stmt->bind_param('ss', $chmod, $city);
$stmt->execute();
$result = $mysqli->query($query);
$result->free();
$stmt->close();
 
// Выбор столбца
$stmt = $mysqli->stmt_init();
$query = 'SELECT city FROM users WHERE chmod = ?';
$stmt->prepare($query);
$stmt->bind_param('s', $chmod);
$stmt->execute();
$result = $mysqli->query($query);
$result->free();
$stmt->close();

require_once 'DbSimple/Generic.php';
$db = DbSimple_Generic::connect('mysql://username:password@localhost/database');
 
// Простой селект
$result = $db->select('SELECT * FROM users WHERE chmod = ? AND city = ?', $chmod, $city);
 
// Выбор столбца
$result = $db->selectCol('SELECT city FROM users WHERE chmod = ?', $chmod);

$mysqli = new mysqli('localhost', 'username', 'password', 'database');
 
// Простой селект
$stmt = $mysqli->prepare('SELECT * FROM users WHERE chmod = ? AND city = ?');
$stmt->bind_param('ss', $chmod, $city);
$stmt->execute();
$result = $stmt->get_result();
 
// Выбор столбца
$stmt = $mysqli->prepare('SELECT city FROM users WHERE chmod = ?');
$stmt->bind_param('s', $chmod);
$stmt->execute();
$result = $stmt->get_result();

$db = new PDO('mysql:host=localhost;dbname=database', 'username', 'password');
 
// Простой селект
$res = $db->prepare('SELECT * FROM users WHERE chmod = ? AND city = ?');
$res->execute(array($chmod, $city));
 
// Выбор столбца
$res = $db->prepare('SELECT city FROM users WHERE chmod = ?');
$res->execute(array($chmod));

//либо
$row = $res->fetch(PDO::FETCH_ASSOC); //для одной записи
//либо
$row = $res->fetchAll(PDO::FETCH_ASSOC); //взять все записи (и поместить в двумерный массив)
//либо 
while($row = $res->fetch(PDO::FETCH_ASSOC)) //в цикле что-то делать с записями (например, выводить)
{
  //to do..
}

$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);

$row = $res->fetch(); //без указания типа возвращаемого значения

$diameter = 7;
$height = 15;
 
// DbSimple
require_once 'DbSimple.php';
$db1 = DbSimple_Generic::connect('mysql://username:password@localhost/database');
$result1 = $db1->select('SELECT * FROM flowers WHERE diameter = ? AND height = ?', $diameter, $height);
var_export($result1); echo '<hr/>';
 
// PDO
$db2 = new PDO('mysql:host=localhost;dbname=database', 'username', 'password');
$wtf = $db2->prepare('SELECT * FROM flowers WHERE diameter = ? AND height = ?');
$wtf->execute(array($diameter, $height));
$result2 = $wtf->fetchAll(PDO::FETCH_ASSOC);
var_export($result2); echo '<hr/>';

$column = 'price';
$id = 4;
$db2 = new PDO('mysql:host=localhost;dbname=database', 'username', 'password');
$wtf = $db2->prepare('SELECT ? FROM flowers WHERE id = ?');
$wtf->execute(array($column, $id));
$result2 = $wtf->fetchAll(PDO::FETCH_ASSOC);
var_export($result2); echo '<hr/>'; // (о.0)!! array ( 0 => array ( 'price' => 'price', ), )

$result1 = $db1->selectCell('SELECT price FROM flowers WHERE id = ?', $id); // '104'

$wtf = $db2->prepare('SELECT price FROM flowers WHERE id = ?');
$wtf->execute(array($id));
$result2 = $wtf->fetchAll(PDO::FETCH_ASSOC);
var_export($result2); echo '<hr/>'; // array ( 0 => array ( 'price' => '104', ), )

$result22 = $result2['0']['price'];

$wtf = $db2->prepare('SELECT price FROM flowers WHERE id = ?');
$wtf->execute(array($id));
$result2 = $wtf->fetch(PDO::FETCH_COLUMN);
var_export($result2); // '104'

$column = 'price';
$wtf = $db2->prepare('SELECT ? FROM flowers WHERE id = ?'); // Добавил плейсхолдер на место названия таблицы
$wtf->execute(array($column, $id)); // добавил переменную перед $id, т.к. плейсхолдер для столбца находится перед плейсхолдером для id
$result2 = $wtf->fetch(PDO::FETCH_COLUMN);
var_export($result2); // 'price'

$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);