Combining vector search and full-text search in SQLite using Reciprocal Rank Fusion for better results

SQL techniques to select complete rows with the maximum value of a column within groups, comparing performance of subqueries, joins, and window functions