I just decided to kick the fflib QueryFactory out of a customer project because of its complexity and sub-par performance.
My Custom Query Building is fast but I fear I will reinvent the wheel.
Which other "lean" (compared to fflib) Query Builder Libs are out there? Which one do you use and why?
Features I would like are:
- Way to centralized fields to query (class, FieldSet, etc)
- Support of Subqueries using same mechanisms
- Leveraging new native Security features
- Fluent API style
- Support of ORDER BY, LIMIT, COUNT etc.