If not modified, the Query string generated is written with double quote around the columns name or conditions or table name
such as => SELECT "id" FROM "users" WHERE "id" = ? which is misundertood by MySQL compiler or executor

ERROR

use Latitude\QueryBuilder\Engine\CommonEngine;
use Latitude\QueryBuilder\QueryFactory;

use function Latitude\QueryBuilder\field;

$factory = new QueryFactory(new CommonEngine());
$query = $factory
    ->select('id', 'username')
    ->from('users')
    ->where(field('id')->eq(5))
    ->compile();

$query->sql(); // SELECT "id" FROM "users" WHERE "id" = ?
$query->params(); // [5]

from latitude.

CommonEngine is incompatible with MYSQL. Use the right engine and everything will work as expected.

from latitude.

CommonEngine is incompatible with MYSQL. Use the right engine and everything will work as expected.

ok. Thank u. You should add this note into the documentation. As Latitude is a huge class, it will be usefull if it's notice in documentation how to use it completly as its the case for Doctrine ORM

from latitude.