join table alias

[siyb]

how do I join a table using an alias like so:

JOIN table_name alias ON ...

[somewes]

You can specify a custom condition clause, or in some simple cases, it will detect the relationship and automatically build the join condition.

In [9]: q = Query().from_table({'account': Account}).join({'user_table': User})
In [10]: q.get_sql()
Out[10]: 'SELECT account.* FROM account_account AS account JOIN auth_user AS user_table ON user_table.id = account.user_id'

In [11]: q = Query().from_table({'account': Account}).join({'user_table': User}, condition='account.user_id = user_table.id')
In [12]: q.get_sql()
Out[12]: 'SELECT account.* FROM account_account AS account JOIN auth_user AS user_table ON account.user_id = user_table.id'

There are other cool things you can do with the querybuilder joins, but there are not code examples in the docs. I'll leave this ticket open until the docs include more examples.

[siyb]

@wesokes thanks you for your swift reply, very much appreciated. Looking at the documentation again, after reading your reply, I've found the part of the documentation that actually describes this behaviour, I should have looked more thoroughly before asking the question, sorry to have taken up some of your time :/

[ksherali]

Please can you give an example for SELECT user.name, group.name FROM user INNER JOIN group ON user.city=group.city WHERE user.date_created BETWEEN '2020-01-01' AND '2020-01-02'. I am struggling to create .where(users.date__range=()) so to put table name before column name "user"."date"