I’ll change it
I’m a bit surprised by the choice of wildcard character. In SQL, this is usually ‘%', not ‘*’, but I guess it does not matter much. do we have a reason to use '*'?
Also do we have a reason to support both Like and matches {/regexp/}? Is like easier to optimize? case sensitivity?
I assume using % is because “select *”, but we don’t have that problem.
Like has limited expression power, surely not at the level of a regex
I spoke to the one implementing AQL, and he said just the wildcards is good to be able to optimize queries, much easier than regexps, so I guess this is good to have.
The first version was using %, but actually this feature was already implemented with * by a couple of AQL implementations, so we just formalize what it is being used out there. For details check discourse links to see what was discussed.