API: Query JSON Metadata
I've talked about this with @dan shortly before and the idea is to be able to store data within the users JSON meta-data and being able to query it directly.
My app has a user with id
123 and the user connects a Hive account and adds
appId: 123 to the meta-data. I'm then able to query metadata via API to get hive account where
API structure would be:
type KeyType = 'posting' | 'active' queryJsonMetadata( key: string, value: string, type: KeyType | KeyType ): HiveAccount | HiveAccount
Raw SQL is something like
SELECT * FROM "users" WHERE CAST ("posting_json_metadata" -> key AS STRING) = value
Would be great if this could get a somewhat high priority as certain features within my app depend on this API functionality.