PostgreSQL query has = operators inside SELECT column references, what does this syntax mean?
<p>SQLALchemy generated the following query for me:</p>

<pre><code>SELECT count(client.id = user_accounting_journal_entry.client_id) AS count_1 
FROM client, user_accounting_journal_entry
WHERE user_accounting_journal_entry.kind = 'debit' 
GROUP BY client.name = user_accounting_journal_entry.client_id
</code></pre>

<p>Note the part inside select: <code>count(client.id = user_accounting_journal_entry.client_id)</code>. </p>

<p>Having mostly used MySQL, I am not familiar with this syntax, and have a hard time finding documentation.</p>