After getting nowhere here and receiving canned email responses from support
I've done a little digging on the SQLite site.
For those interested it looks like Adobe Air's implementation of SQLite in 2.0beta is closest
to a version released between
2009 Jan 12 (3.6.8)
- Added support for nested transactions
2009 Oct 14 (3.6.19)
- Foreign Key support was added.
Spoke too soon about support.
Here's the official response
AIR 2.0 has SQLite , AIR 1.5 had 3.6.1
I believe that Flex 3.x used AIR 1.5, Flex 4 is currently using AIR 1.5.3.
I understand it's not yet implemented in reference to the release date of SQLite (Oct 2009), but hope it's on their agenda
Ps: If you need this too, please file a feature request: