Spatial SQL subquery in definition query to filter layer or label

[GaetanPRU]

Hello,

I saw in ArcGIS PRO documentation that it's possible to use SQL subqueries in definition queries.

I would like to know if it is possible to use spatial function like st_intersects or st_within to dynamically filter a layer or create label classes.

I tried this subquery in definition query but when I check this request it's OK but I can't apply it :

OBJECTID IN (SELECT TABLE2.OBJECTID
FROM SCHEMA.TABLE1, SCHEMA.TABLE2
WHERE SCHEMA.TABLE1.NAME= 'xxxx' AND 
SDE.ST_INTERSECTS(SCHEMA.TABLE1.SHAPE, SCHEMA.TABLE2.SHAPE) = 1 ;

I work with ArcGIS PRO 2.6.2, maybe it's possible in newest version.

Thanks