Does FireDAC TFDQuery apply Limit and Offset server-side or client-side?
Goal: Page through a large dataset using TFDQuery Limit and Offset while avoiding full-table downloads to the RAD Studio client. FireDAC translates Limit and Offset into native SQL when the connected server and driver support pagination. For older servers without native OFFSET or FETCH support, the library may instead retrieve all matching rows and apply the
radstudio