Is it possible to concatenate multiple columns into one?

[alijarjis-pol]

Does anyone know how I could concatenate multiple columns into one using bun? i.e.

select concat_ws(', ', location_address_line1, location_address_line2) AS address FROM branches;

[alijarjis-pol]

This question can be ignored, I was trying the following and kept getting an error until I realised I was using sqllite which doesn't support concat. The following below works just fine in postgres.

ColumnExpr(`concat_ws(', ', location_address_line1, location_address_line2 as "Address"`)