added further SQL support including auto-gen id support for elastic, unique id field needs to be captured