The [?...] syntax in queries has (rightly) been slated as user-unfriendly. So, add an alternate operator,
so you can write
attachments[where author='SalvadorDali' AND size>9000]
Also criticised is support for general REs. Simplify this support down to the subset supported by LIKE. This will ease mapping to DBI, too.
Note that because of the existing usage of the % character for TWikiVariables
, we will have to use * for the % wildcard in SQL LIKE. I also propose to use ? rather than _ for the single character wildcard.
- 22 May 2007