[FINERACT-1058] Add support for "limit" and "order by" query in SQLBuilder

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Mihaly Dallos
• Reporter: Manthan Surkar
• Created: 29/Jun/20 09:54
• Updated: 05/Dec/23 18:39

Description

This is in continuation of the work done by Michael Vorburger in https://github.com/apache/fineract/pull/725
The SQL builder currently does not support limit and order by operation. We can either keep the operations independent of SQLbuilder (which is certainly not recommended imo) or add it as a part of it.
WDYT Michael Vorburger Awasum Yannick

Issue Links

• Blocked: FINERACT-1095 Remove direct sqlSearch support from /clients and all other APIs [Security & Performance]
• is related to: FINERACT-854 Use prepared statements instead of string concatenated SQL everywhere