Hi @NeerajIyer
QuickSight supports only select statements currently. Any custom SQL that you use to create a data set should also be a select query.
We have a product feature request in place to support stored procedures, however, we do not have an ETA on when it would be generally available.