Sequence generator needed for key data items.
Using Autonumber is not desirable to use as a key-field in a table as a related field to another.
First, Caspio allows the user to re-number, although with warnings, it could still corrupt your database with orphan links left behind. Also you can only create a join with another like "autonumber" (can't use a number field).
Suggest a fix for above, or create a new sequence generator similar to what Oracle has.
We are happy to let you know that the feature has been available since September of 2015. Sorry for the late notification. More details at http://howto.caspio.com/release-notes/caspio-bridge-8-8/