I have seen your package but that is not what I am looking for. Your object is to support SQL directly to the in memory tables. I want more like Delphi's ClientDataSet functionality over an already existing client-server database:
1. Specify a different SQL to SELECT, UPDATE, INSERT.
2. Buffer edits to the underlying dataset and then apply them seperately with ApplyUpdates.
3. Specify how many records to retrieve at a time for very large dataset and automatically do so when scrolling.
etc