For

In SQL Server, FOR clauses are how you can return JSON or XML directly from your query.

In qb, only raw expressions are accepted via the forRaw method.

forRaw

Name
Type
Required
Default
Description

expression

string

true

The raw sql for the FOR clause.

QueryBuilder
query
    .select( [ "id", "name" ] )
    .from( "users" )
    .forRaw( "JSON AUTO" );
SQL Server
SELECT [id], [name]
FROM [users]
FOR JSON AUTO

Was this helpful?