Does the normal query use inner join under the hood?

What does the db.query() function use under the hood? Is it better to use innerJoin() for complex queries rather than the normal query(), findMany() and with:?
Was this page helpful?