Can this query translate to kysely?

sql`SELECT 
      frr.reimbursement_request_id,
      frr.reference_no,
      frrt.request_type,
      fret.expense_type,
      frrs.request_status,
      frr.amount,
      frr.attachment,
      frr.attachment_mask_name,
      frr.remarks,
      u.full_name,
      u.email,
      u.employee_id,
      u.hrbp_approver_email,
      frr.payroll_date,
      frr.date_approve,
      frr.created_at,
      frr.cursor_id::TEXT
      ${
        data?.text_search
          ? sql`
      ,ts_rank(to_tsvector('english', coalesce(frr.text_search_properties, '')), websearch_to_tsquery(${data.text_search})) AS rank`
          : sql``
      }  
    FROM finance_reimbursement_requests as
    WHERE to_tsvector('english', coalesce(frr.text_search_properties, '')) @@ websearch_to_tsquery(${data.text_search})
    ORDER BY rank DESC
Was this page helpful?