Based on whatever info i could find and some trial and error i am listing my findings here. This is for people like me who are just starting with FlutterFlow and this could me a common scenario .
There are 3 type of database queries that can be used
1)Query Type 1 - not Single Time, not Infinte Scroll .
I am finally using this as this works well with firebase to reflect the db changes in real time automatically. Works with record addition, deletion, updation so far. The only issue here is depending on your use case you may not want retrieve all the records and may need pagination . That is where ideally the infinte scroll would have been useful, but i have found some limitations with infinite scroll which i have detailed below.
2) Query Type 2 - not Single Time, Infinte Scroll (pagination)
This works well when you want dynamic pagination. But i found that this does not reflect additions and deletions. Only reflects updations. So for this you have to take a not so elegant approach and some long winded steps to get the page and data to refresh using "Navigate to" seems to be the best option i have found. But found this causes issues (passing parameters, forward/Back, navigation gets confusing) depending on your use case. Couldn't really find any other approach so far.
3) Query Type 3 - Single Time Query (This is also suitable for other DB's where you dont get realtime updates from the DB like FireBase)
In this case you can refresh a listview using the "Refresh Database Request" action available. The issue you may face is the ListView is on the Page and the db change is done in a component which was used by the page. I found that you can pass an page action (where you can call the listview refresh) as a parameter to the component. In the component you can then call that action using the "Execute CallBack" when ever appropriate. Ex: If you have a create component , after doing a DB insert you can call the Page Action using the execute callback. This will refresh the listview data on the Page.
Hope this helps in some way in what you are doing.
Ideally if the Query Type 2 (Infinite Scroll) could have an option to refresh (like point 1 or point 2) would have been perfect. But I didn't find any option for that.
Regards
Ganesh