Support select distinct with multiple columns

[kiru]

SQLite does support selects with multiple joins, but with ecto I get an exception:

An exception is thrown at this place:

sqlite_ecto2/lib/sqlite_ecto/connection.ex

Line 242 in 7ba0b62

raise ArgumentError, "DISTINCT with multiple columns is not supported by SQLite"

Is this just a not-implemented case?

What is the return value of the distinct method? (I am not that familiar with the codebase)

edit:
It seems some select statement with distinct works. Can anyone explain this case?

https://github.com/elixir-sqlite/sqlite_ecto2/blob/master/test/sqlite_ecto_test.exs#L203