Please see this link on a bug I found on the new List view:
SQL Query Running Once, Subsequent Times Fail. Preview Always Works - App Building - Retool Forum
Subsequent query runs while using the new list view are failing. Requires a deletion of the listview for queries to run again.