Fix UPDATE FROM in sqlite

There was a bug in how sqlite was updating data from joined tables, in that it would possibly select any random row from the database to use for updating.

This makes sure the FROM clause is linked to the original table.

updates to sqlite

Updates for sqlite broke down when using multiple tables. This adds that capability.

Fix some issues with sqlite and create table statements

Full Changelog: v0.2.0...v0.2.1

Update sqlite datetime type

Now supports DateTime, SysTime, and Date types for sqlite.

The text storage format for these types is now ISOExt, instead of simple format. The sqlite spec actually explicitly specifies this format for date types!

This is a breaking change, which means a bump in the minor rev (would be a major bump, but this is still beta).

Fix issue with sqlite and version dependency

Minor updates, this fixes an issue where the D sqlite library was setting a value to null instead of an empty string.
The version specs were wrong as well, the mysql-native version specifier at least is currently impossible.

Update dependency specs

No longer requires older versions of sqlite and mysql-native (when it changes).

SQLite support

This release adds SQLite support.

Some breaking API changes from 0.0.x branch, but the API is very much in flux. Mostly the change is implementation details and how to hook custom serialization.

Fix CTFE issue with adding columns to a query

Just a minor fix that allows more at CTFE.

Detect stale connections on mysql-native and retry

This utilizes the new MYXStaleConnection exception in mysql-native v3.2.4 to retry a command/query when it detects a stale connection.

Not quite ready

I need a release to properly manage dependencies, so this is going to be it.

No particular level of completeness here. The docs are not ready. There is no CI yet. Postgres and sqlite are fantasies, not even started.

mysql support is pretty robust and working. I'm not super-happy with all the API, so it may change.