upsertMarket(where)

and

market(where)

are both

WhereUniqueInput

so I also can not look up a

market

by anything other then it's ID ...

You can always add

@unique

directive to the fields and then you would be able to query the corresponding node by providing a value for that field as a query argument.