Within promise SQL not able to execute multiple queries

[ronak2810]

Within a promise txns with both SELECT and INSERT/UPDATE sql cannot be executed. On running SELECT sql, the promise is automatically resolved before executing the other sqls like INSERT or UPDATE