Using raw subquery when defining filters in service/resolver

[mikitu]

I need to filter something like this:
const filters: Filter<Item> = {userId: {in: Sequelize.literal(sql here)}}
is it possible?

Thanks

[awHamer]

No, the filters are high lever of abstraction that is not supposed to know something about SQL...
You can try to overrideTypeormQueryBuilder and pass it to constructor of TypeormQueryService,
or you can add this directly to queryBuilder in TypeormQueryService.query