Core: Database raw sql

Sometimes it is necessary to use a raw sql query as part of the main query.
I already suggested this, but as part of other changes. And now I would like to know your opinion on the implementation of this as an independent tool.

This solution will help bypass the unwanted raw sql processing and use it as is.

PHP Code:

class SQLExpression
{
    protected $query = '';

    /**
    * @param string $query
    */
    public function __construct(string $query)
    {
        $this->query = $query;
    }

    public function __toString(): string
    {
        return $this->query;
    }
}

function sql(string $query): SQLExpression
{
    return new SQLExpression($query);
} 


Usage

PHP Code:

$db->select(sql('a + b AS c'));
$db->from(sql('SELECT * FROM ....'));    
// etc 


// Raw sql detection

PHP Code:

public function from($from, bool $overwrite = false)
{
    if ($overwrite === true) {
        $this->QBFrom = [];
        $this->db->setAliasedTables([]);
    }

    // here detection

    if ($from instanceof SQLExpression)
    {
        $this->QBFrom[] = $from;
        
        return $this;
    }
    
    // ....
} 


I think that would add a lot a flexibility for more complex queries. Good idea!

I sent a PR.
https://github.com/codeigniter4/CodeIgniter4/pull/5817

Any comments?

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

@kenjis Thank you for your work

Thank you.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

I have not yet created a helper function.
Do you need it?

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

Since v4.2.0,
QueryBuilder select(), where(), like(), join() and
DBForge::addField() default value accept the RawSql instance.

See https://codeigniter4.github.io/CodeIgnit...l#database

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

Thank you