See test cases: https://github.com/invio/Invio.QueryProvider.MySql/blob/03146ab71130177e68285bb907676ad29b972341/test/Invio.QueryProvider.MySql.Test/MySqlQueryableTest.cs#L95-L101 Adding support for joins involving a subqueries may or may not involve additional work. If so, open a separate issue to support this as well.
See test cases:
Invio.QueryProvider.MySql/test/Invio.QueryProvider.MySql.Test/MySqlQueryableTest.cs
Lines 95 to 101 in 03146ab
Adding support for joins involving a subqueries may or may not involve additional work. If so, open a separate issue to support this as well.