Support Change Data Type in SQL Query Folding

If at all possible (not a SQL statement person) it would be nice if you could change the data type and have PQ fold that into the SQL statement. There are a lot of cases where data is stored in other formats. For example, we have a General Ledger table where the date is stored as MM/DD/YYYY, but as TEXT! So to do any filtering on it I need to convert to Date, but then that breaks Power BI's ability to continue folding the query as a SQL statement.

There are sometimes workarounds, but not always, and it is always a pain.