updated SQL templates to support attribute pool and identity parameters