Querybuilder select() parsing problems

CodeIgniter 4.5.1
PHP 8.2

PHP Code:

$builder = $this->db->table('sales_items');
$builder->select("name, CONCAT(IFNULL(ROUND(percent, 2), 0), '%') AS percent, sales.sale_id AS sale_id, sales.foo AS subtotal");
$sub_query = $builder->getCompiledSelect(false); 


Generates

Code:

SELECT `name`, CONCAT(IFNULL(ROUND(percent, 2), 0), '%') AS percent, `ospos_sales`.`ospos_``sale_id` AS `sale_id`, `ospos_sales`.`foo` AS `subtotal`
FROM `ospos_sales_items`

The QueryBuilder parser is incorrectly appending the database prefix to the column name sale_id and it's escaping the column moniker after the 'AS' keyword in the second and third column names.

If I add `false` as the 2nd parameter in the select() call

PHP Code:

$builder = $this->db->table('sales_items');
$builder->select("name, CONCAT(IFNULL(ROUND(percent, 2), 0), '%') AS percent, sales.sale_id AS sale_id, sales.foo AS subtotal", false);
$sub_query = $builder->getCompiledSelect(false); 


It generates

Code:

SELECT name, CONCAT(IFNULL(ROUND(percent, 2), 0), '%') AS percent, `sales`.`ospos_sale_id` AS `sale_id`, sales.foo AS subtotal
FROM `ospos_sales_items`

For some reason it didn't get the memo about not escaping because it still escaped part of the query and it's now adding the database prefix to the column name but NOT adding it to the table name.

I tried removing the aliasing from the query, but that had no effect on the problems.

Removing the CONCAT SQL function call gets rid of the problems with prepending the prefix to the column but not the escaping problem

PHP Code:

$builder = $this->db->table('sales_items');
$builder->select("name, sales.sale_id AS sale_id, sales.foo AS subtotal", false);
$sub_query = $builder->getCompiledSelect(false); 


yields

Code:

SELECT name, `sales`.`ospos_sale_id` AS `sale_id`, sales.foo AS subtotal
FROM `ospos_sales_items`

Why is QueryBuilder->select() escaping these column and table names when the 2nd parameter of select is false?

Even wrapping the contents of the select() in a RawSql() instance still has it prepending the prefix in the wrong places.