SQL Operators as API Filters

When you write SQL that resolves to API calls, you want a SQL operator like > to influence an API call in the expected way.

Consider this query:

You would like the underlying API call to filter accordingly.

In order to intercept the SQL operator, and implement it in your table code, you declare it in the KeyColumns property of the table.

Then, in your table code, you write a handler for the column. The handler configures the API to filter on one or more operators.