Did you find a solution? I'm trying to do the same thing.
It looks like Illuminate\Database\Query\Grammars\SqlServerGrammar uses a "compileFrom" function. This compiles the lock based on $query->lock
I've tried using this but I'm getting 2 outputs of "with (nolock)" like the below sample query.
select * from
users with (nolock) where
id = 1 limit 1 with (nolock)
Sign in to participate in this thread!
We'd like to thank these amazing companies for supporting us