A frequently raised question revolves around whether you can directly incorporate Retrieval statements within CONSTRAINT clauses in SQL. While seemingly appealing, this isn't typically supported in a simple fashion https://vinnytyng937481.blogdigy.com/exploring-using-queries-in-where-clauses-a-database-deep-look-61673064