convert query to CI 3 query builder

Code:

Hello team i hope you're doing well i have a query which i want to convert to CI 3 query builder

with t as  (
            select    regexp_substr(TAG_ID,'\d',1,level) as ID
                      ,count(*)                          as NUB_of_POSTS
            from      post 
            connect by ID = prior ID and level <= regexp_count(TAG_ID,'\d') and sys_guid() <> prior sys_guid()
            group by  regexp_substr(TAG_ID,'\d',1,level)
          )
select    NAME
          ,NUB_of_POSTS
from      t join tag using(ID)

You probably will not get an answer to your question because most users have moved over to
CodeIgniter 4 so they do not have CodeIgniter 3 installed anymore.

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

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

You can't.
Query Builder does not support WITH clause.

Why do you need to use Query Builder?

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

@optic4predator1 ,

You might want to try query binding instead (https://codeigniter.com/userguide3/datab...y-bindings). It may give you the results that you are looking for.