regex for string match

[jedi1992]

Most examples have a == for string equality match. How to use regex or simple things like %string% in logica predicates .

[EvgSkv]

SQL's like operator is available with Logica's Like function.
Also all of BigQuery functions with simple syntax are available in Logica came-cased.
Here is an example.

Word("dog");                                                                                                                      
Word("cat");                                                                                                                      
Word("dome");                                                                                                                     
Word("house");                                                                                                                    
                                                                                                                                  
MatchingWord(x) :- Word(x), Like(x, "do%");                                                                                       
RegexpExtractExample(y) :- Word(x), y == RegexpExtract(x, "o(.)");                                                              
RegexpMatchExample(x) :- Word(x), true == RegexpContains(x, "^...$"); 

Functions that aren't supported out-of-the-box can be implemented with SqlExpr function.
Here is an example of using SQLite's GLOB.

@Engine("sqlite");
Q(s) = SqlExpr("{s} GLOB '{glob}'", {s:, glob: "*a*"}) :-
   s in ["cat", "dog", "bag", "tag", "fire"];