Identity and Surrogate Keys in FactEngine Query Language (FEQL)
The finer points of how FactEngine semantic parsing works
In the query above, a provider is identified by their name, Kathy Snelling, but how does FactEngine know that a provider is identified by their first name followed by their last name? Why isn’t it last name followed by first name?
If we look at the entity relationship diagram for the schema over which the query operates, we can see that the Provider entity has a primary key of Privider_Id and a…