ANN Vector Search with SQL-Powered LSH and Random Projections

Is anyone successfully running LSH in production? The technique seemed promising ten years ago but I'm not sure if reality matched that...