Can I use multi (sub) levels of relation (AND | OR) on custom query?

Can I use multi (sub) levels of relation (AND | OR) on custom query?