Problems with sqlsrv DB driver and CI 3

For people getting the same errors with subselects in the form() method you can bypass the escaping with parenthesis.

Not working example:

PHP Code:

$this->db->from("(SELECT field, max(field2)
                            FROM table
                            WHERE field3=1
                            GROUP BY field) con"); 


Working example:

PHP Code:

$this->db->from("(SELECT field, max(field2)
                            FROM table
                            WHERE field3=1
                            GROUP BY (field)) virtualTable");