Warn and allow non-indexed column search

We can turn on filtering for non-indexed columns, but we need to warn and get confirmation from the user before applying the filter to the databases table.

When allowing users to search on a non-indexed column, present a warning to get confirmation from the user before executing the query. The warning should inform the user that the query could be very expensive and may result in degraded server performance. Additionally, ensure that the query requires an `allowFullScan` flag to be explicitly enabled.