There is a known bug in the Basic Application Wizard where if your BAQ has subqueries, the grids get created with all columns including those in subqueries that are not in your top level.
Then the way the provider model works is it runs the BAQ with a select list of columns and because of the above this can now cause the SQL error you are seeing because the columns do not exist to the top level.
Therefore when this happens you need to your grid after the app has created and go to Grid Model > Columns and review the list of columns and delete any that are not in your top level. Alternatively I believe you can now (depending on version) use the grid wizard to run through the column set up again.
Are those columns it is erroring with in your top level? If not delete them out of the grid and try again.