Instances:

Search all instances that aren't suppressed and that have no holdings/items attached and that aren't boundwiths and are source = marc
Search all instances that aren't suppressed and are source = folio with a status of Awaiting receipt in the POL over a certain period of time
Search all instances that aren't suppressed that have any information in the Electronic access fields (including the URL Relationship; marc srs 856)
Search all instances that aren't suppressed that don't have eng as the language of cataloging
Search all instances that aren't suppressed that are missing format and type information
Search all instances that aren't suppressed that are invalid
Search all instances by contributor
Search all instances by subject
Search all instances by title
Search all instances cataloged between specified dates
Search all instances created between specific dates
Search all instances updated between specific dates
Search for instances that are suppressed in Location “Music Storage,” with material type “Media,” and not mode of issuance not ‘serial.’
Search for stat code “OUP-EBA-PUR-2023,” with create date “TODAY.”

Holdings:

Search for our local holdings records for our print serials and retrieve only those holdings and not all holdings attached to that instance. For example, we have print serials in special collections and general collections on the same record and I need only the one in general collections.
Search for holdings records that aren't suppressed where one of the fields in the Electronic Access array is missing like relationship type or link text or public note.
Search for holdings records that aren't suppressed where one of the fields in the Electronic Access array is X for the relationship type or link text or public note.
Search for holdings that aren't suppressed that is connected to an instance that isn't suppressed and where there is only that holdings record.
Search for call number in holdings that have whitespace before or after and/or a return.
Search for holdings that are only in a certain location or set of locations either permanent or temporary.
Search by statistical code.

Search for items that were created during a certain time period and then updated during a certain time period with the status of in process
Search for items with one or many item statuses
Search for item records in one or many locations either temp or perm
Search for particular item material types
Search by barcode, HRIDs and UUIDs
Search instances that are for eResources where there is one holdings record and on that holdings have more than one item record.
Search for open loans (items status = checked out) due on a specific date.

Search all bibliographic marc srs records for an 008 that is an invalid length (less or more than 40).

General question: How should the records identified by each query be acted upon?
By suppression of instance records do we mean Staff suppress or Suppress from discovery?
How do you define local holdings? Holdings with permanent or temporary location associated with a specific library?
Should search by statistical code be available on each inventory record level?
Is the search by barcode/uuid/hrid just by one barcode or multiple? How this relates to uploading a file with identifiers?
How do you determine that the instance is for eResource?
How would you identify student worker?