Add a prefix value to inside a db query

So im looking for a way to add a prefix value inside a db query. I have looked online but could not find anything about this so my guest is that this is not possible.

// the Idea

 $query->select( '{my-prefix-here}language , slug' )->from( 'blog'  )->all();

// current output

[

     array(


          language => my prefix here hello world haha // add a prefix before this value 

          slug         => hello-world-haha


     )

]

Sql Concat?

->select(“concat(‘myprefix’,language) as lang”)

Yes this works, how stupid of me I was using

CONCAT( '' , 'prefix' , language)

which did not work haha