\s+[^\s\(\)]+\s+[as|AS]+\s+(([\w\.]+))

with missed_ops as (
    select ls.lead_id,
           ls.lot_sale_id,
           ls.bid_dtls,
           JSON_UNQUOTE(REPLACE(JSON_SEARCH(ls.bid_dtls, 'one', '100003', NULL, '$.bids[*].companyId'), '.companyId',
                                '.bidAmount')) as bidAmtPath
    from lot_sales ls
    WHERE JSON_SEARCH(ls.bid_dtls, 'one', '100003', NULL, '$.bids[*].companyId') is not null
      and ls.mbr_cmp_id != 100003
)
select l.make_cd                                                as makeCode,
       l.model_cd                                               as modelCode,
       l.year_of_manuf                                          as yearOfManufacture,
       l.lead_id                                                as leadId,
       l.odo_dtls                                               as odometer,
       l.title_cd                                               as titleCode,
       l.odo_metric                                             as odometerUnit,
       l.eng_trans                                              as engineAndTransmission,
       l.run_cond_cd                                            as runConditionCode,
       l.dmg_cd                                                 as damageCode,
       lpl.city                                                 as city,
       lpl.state_cd                                             as stateCode,
       l.crt_dt                                                 as createdDate,
       missed_ops.bid_dtls                                      as bidDetails,
       JSON_EXTRACT(missed_ops.bid_dtls, missed_ops.bidAmtPath) as yourBid
from missed_ops
         join lots l on l.lot_sale_id = missed_ops.lot_sale_id
         join lot_pickup_location lpl on l.pickup_location_id = lpl.pickup_location_id
    and l.crt_dt > DATE_ADD(Now(), INTERVAL - 30 DAY)
    and l.status = 'A'
order by createdDate desc;