Logica compiles to SQL. It is semantically equivalent but not syntactically so the gain has to be in differences in the grammar. I see that one can create pred

Logica compiles to SQL. It is semantically equivalent but not syntactically so the gain has to be in differences in the grammar. I see that one can create predicates (functions) with parameters as a means for code re-use. I could also see that having implications for testability. That's interesting. I could see how one could build a DSL with Logica to make fairly tricky queries easier. That's interesting. Has anyone used this? If so could you explain how are SQL functions called? Do they have to specifically exist in Logica or are they just assumed to exist in SQL? (I'm thinking about geographic functions in particular for example. Are window functions also possible in Logica?