SQL Server compatibility

[henergy-dev]

Hello, recently we had to implement your driver into our Laravel project because of (hoping) a temporary solution to store files. The good news is it's awesome, the bad news came when we were told to migrate to SQL Server.

We made a little test on a fork for this driver and made it successfully compatible with SQL Server (tested on SQL Server 2019), both migrations and functions.

We didn't generalize the implementation since it should be temporary for us and a fork with the changes is sufficient, but could there be an interest for a pull request if the work is properly done?

[Pudge601]

Hi, thanks for the interest in this project!

Adding SQL Server compatibility sounds useful, we would certainly be open to a pull request.

It looks like most of the changes to add compatibility are to modify the SQL syntax for things like limiting to only the first row, do you have an idea of how you’re thinking of making it work for handling this while maintaining MySQL/SQLite compatibility?