How to translate such a query into Flask-SQLAlchemy?

Question

Flask

Here is the sql query:

SELECT a.*, b.*,
(SELECT max(date_call) from call_history WHERE client_id = a.id) as last_call,
(SELECT call_date from call_remind  WHERE  client_id = a.id) as call_remind
FROM clients a 
INNER JOIN contacts b
WHERE 
a.user_id = 208
AND
a.id = b.client_id

Can you please tell me how to convert it to SQLAlchemy?

Answer 1

https://chartio.com/resources/tutorials/how-to-exe...