title: How to use LEFT JOIN LATERAL in typeorm?
body: <p>I want to use below query in TypeOrm but can't find a way to convert it to TypeOrm.</p>
  <p>Any help is appreciated.</p>
  <pre><code>SELECT * FROM blocked_times bt 
   LEFT JOIN LATERAL (
        SELECT * FROM bookings bk WHERE bt.&quot;startTime&quot; &lt; bk.&quot;endTime&quot;
   ) bk ON bk.&quot;clinicId&quot; = bt.&quot;clinicId&quot;
  </code></pre>