MySQL backend

[kszucs]

I guess mysql would be a nice to have backend.

Should it be based on the alchemy backend or the sql compiler (like impala, clickhouse and bigquery)?

[wesm]

This would also provide MemSQL support. I will see if anyone from over there would be interested in contributing

[kszucs]

Sounds great, thanks!

[cpcloud]

@kszucs This should be based on the alchemy backend.

[kszucs]

@cpcloud BTW what's the advantage of maintaining both sqlalchemy and custom compiler backends?

[wesm]

Depends on how well sqlalchemy supports the underlying SQL backend. In the case of Impala and BigQuery there's a lot of stuff that is challenging to support in SQLAlchemy (or maybe it's that we don't know how to use it well enough)

[kszucs]

I get it, but also bothers me a bit.

When I look at ibis' custom compiler it feels like another sqlalchemy.
When I look at sqlalchemy backends it feels like I have double vision, mapping ibis expr to sa expr.

Couldn't we move away from either one? (I know there are pros&cons for both backend types)