QuestDB implements regex string match with the operators ~= and !~. However, LIKE is not implemented.

Describe the solution you'd like
Implement LIKE such that
column LIKE pattern becomes ~=(column, pattern)
NOT column LIKE pattern becomes !~(column, pattern)

For example, given a simple pipeline such as:

Pipeline p = Pipeline.create();
p.readFrom(TestSources.items("the", "quick", "brown", "fox"))
 .aggregate(aggregator)
 .writeTo(Sinks.logger());

I'd like aggregator to be something requiring a non-serialisable dependency to do its work.

I know I can do this:

Pipeline p = Pipeline.create();
p.readFrom(TestSource