Calling expression data in batches

What exactly is your question?  What requirement do you have and what trouble are you having fulfilling it?  What have you already tried and found not to work as expected?

No, you do not want to show the whole database table in a grid.

Hello [mention:bb176b67c26c4e89b2173f39160c9f46:e9ed411860ed4f2ba0265705b8793d05]  

Since you are using the expression rule for your grid's data source, whatever batch size you have configured in the query will be the number of rows you will be able to display in the grid. Also your pageSize parameter in the grid will define the number of rows to be displayed in the current page. Also If you want all the records in the grid you can use the recordData() for the data parameter in the grid instead of your expression rule. Do not show all the rows in a single page, It would not be a good user experience.

You can use batch size as -1 to pull all the rows from the table and use it to display in the grid. 

But it is strictly not advisable keeping the SAIL performance in mind

See the Paging section of Read-Only Grid documentation to get more ideas. There are multiple ways like grid-managed paging, direct query, query using an expression rule, etc.

https://docs.appian.com/suite/help/24.3/read-only-grid-configuration.html#paging-and-sorting