title: Firestore database query, ignore case (case insenstive) and like clause.
body: <p>Basically I am writing a search function on a Firestore document field. I want to write equivalent of below SQL. I am not finding solution to proceed.</p>
  
  <p>SELECT *
  FROM employee
  WHERE lower(employee_name) LIKE '%johny%';</p>