This is SQL syntax, so it is not evaluated by Qlik Sense. Instead it is evaluated by the ODBC driver / OLEDB provider. So, what's possible or not depends on which ODBC driver you use...
A work-around is to use a preceding Load:
Load *, If(Status='Rejected', Status, 'Accepted') as Status2;
SQL SELECT ... FROM ... ;
Then the Load is evaluated by Qlik Sense.
Thanks for the response...
Turns out all I had to do was change the wildcard from '*' to '%' and it worked fine.
I understand now that '%' works for sql select statements and if you need to use a wildcard from a csv file, you need to use '*'.
Thanks again so much for taking the time to look into this.