Bug when changing table to SQL statement: Expression Error.: The key didn't match any rows in the table

Bug:
you get the error:
Expression Error.: The key didn't match any rows in the table

if you:
connect to a database
select any table and load it
click home - edit queries
click source under applied steps
click advanced options in the popup
type SQL statement e.g. select * from [yourtablename]
click ok
click close and apply
You now see the error above (Expression.Error: The key didn't match any rows in the table)

Solution
click home - edit queries
under applied steps, remove navigation
click close and apply
The error is fixed, but the user shouldn't have to do these last steps