It is possible to implement Hybrid Search in pure SQL, but the resulting query can be hard to understand if you don't have too much experience with Common Table Expressions (CTEs). In this article, we will dive deeper into CTEs and the finer details of the query.