Level 39
\DB::statement("your_sql");
Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
How to convert this query to Query Builder syntax ?
SELECT
c.ordinal_position,
c.table_schema,
c.table_name,
c.column_name,
pgd.description,
c.udt_name as udt_name
FROM pg_catalog.pg_statio_all_tables as st
LEFT JOIN information_schema.columns as c
ON c.table_schema=st.schemaname and c.table_name=st.relname
LEFT JOIN pg_catalog.pg_description as pgd
ON pgd.objsubid=c.ordinal_position and pgd.objoid=st.relid
WHERE
st.schemaname NOT IN ('pg_catalog', 'information_schema');
Sorry I replied too quickly
$result=DB::select("your_select_sql)");
https://laravel.com/docs/8.x/database#running-a-select-query
Please or to participate in this conversation.