Other joins besides INNER JOIN

[manueltimita]

What a clever little gem! Been looking for a while for a smart SQL query builder - basically a JS alternative to HTSQL.

Query Builder looks very promising, and I have a question. I looked in the tests and examples, and the only join I see exemplified is INNER. Is QB trying to detect, perhaps based on cardinality, which join is the most optimal for the given tables and then does that automatically?

Otherwise, what is the best strategy. Define a custom function?

Thank you.