Datagridview filter on database view

Question

My database contains two tables and two views. So far I've been able to filter my DataGridViews that are bound to the tables just fine by using code like

myBindingSource.Filter = String.Format("columnName LIKE '{0}*'", FilterBox.Text);

Only problem is, when I use that format for my DataGridViews that are bound to my Database Views I get "EvaluateException was unhandled" "Cannot find column [columnName]". I've triple checked that the column names are correct and have even gone to the database to confirm that

SELECT * FROM tableName WHERE columnName LIKE 'value'

indeed works. I am using SQLite as my database. Any tips on how I can filter on the views?