With condition

I am using db.query to fetch some data with a lot of related data.

One of the

with

with

statements is only applicable if a column value from another joined table is a certain value.

Does

with

with

support a

where

where

that uses another joined tables data? If so, what does the syntax look like?