Frontend API, Data querying in custom plugin

[grafzahl-io]

Hi everyone,

we are considering budibase for a new project and need to develop some custom
plugins.
In my first test, I build some queries with sdk frontend api (const { API } = getContext("sdk")).
For a simple load of meta data it worked very well like this:

const media = await API.searchTable({
	tableId: mediaTable.tableId,
	query: {
		equal: {
			_id: video
		}
	},
	limit: 1
});

But when it comes to filter by a foreign key relation, it is not as intuitiv as expected.
And until now I could not find any reference or help within the docs or source code.

Can anybody help me to filter a table by a foreign key? I already tried a few things in combination of the
below code (combining different conditions and structure of the fields.
video in this case, is the uuid of the foreign table:

const annotations = await API.searchTable({
	tableId: annotationTable.tableId,
	query: {
		equal: {
			media:  video
		}
	},
	paginate: false,
	limit: 1000
});

const annotations = await API.searchTable({
	tableId: annotationTable.tableId,
	query: {
		contains: {
			media {
                             id:  video
                        }
		}
	},
	paginate: false,
	limit: 1000
});

The first query returns all entries, the second zero.