How can I delete entries from a search object without deleting the corresponding row in my datatable?

[campopianoa]

The search iterator is connected to the database rows.

If you want to decouple that object from your database, I believe you must cast the search iterator to a list of dictionaries, then you can treat it as a Python list.

Please see this recent post about casting:

DB row as dictionary

How do I cast a DB row as a dictionary? Yes, I could do it by extracting all the values and setting all the keys of a new dictionary. But I want to do something like row_dict = dict(row) since the thing is so much like a dictionary already.

For example,

# on the server
my_list=[dict(r) for r in app_tables.my_table.search()]