INSERT INTO da.pdenprodapi14_testm (api14,prod_date,api10,
    prod_month_no,liq,gas,wtr,days,
        cum_oil,cum_gas,cum_wtr,
        entl_region,entl_country,entl_state,entl_county,
        entl_offshorecode,is_deleted,mfg_created_at,
        mfg_deleted_at, mfg_updated_at, updated_at)
    VALUES
    {{range $idx, $obj := .}}
    (
    {{unwrap $obj.Api14 | quoteSQL}},
    to_timestamp({{unwrap $obj.ProdDate | quoteSQL}}, 'YYYY-MM-DD HH24:MI:SS.MS'),
    {{unwrap $obj.Api10 | quoteSQL}},
    {{unwrap $obj.ProdMonthNo}},
    {{unwrap $obj.Liq}},
    {{unwrap $obj.Gas}},
    {{unwrap $obj.Water}},
    {{unwrap $obj.Days}},
    {{unwrap $obj.CumOil}},
    {{unwrap $obj.CumGas}},
    {{unwrap $obj.CumWtr}},
    {{$obj.Entitlements.EntlRegion | quoteNullableSQL}},
    {{$obj.Entitlements.EntlCountry | quoteNullableSQL}},
    {{$obj.Entitlements.EntlState | quoteNullableSQL}},
    {{$obj.Entitlements.EntlCounty | quoteNullableSQL}},
    {{$obj.Entitlements.EntlOffshorecode | quoteNullableSQL}},
    {{unwrap $obj.IsDeleted | quoteNullableSQL}},
    to_timestamp({{unwrap $obj.Metadata.CreatedAt | quoteNullableSQL}}, 'YYYY-MM-DD HH24:MI:SS.MS'),
        to_timestamp({{unwrap $obj.Metadata.DeletedAt | quoteNullableSQL}}, 'YYYY-MM-DD HH24:MI:SS.MS'),
        to_timestamp({{unwrap $obj.Metadata.UpdatedAt | quoteNullableSQL}}, 'YYYY-MM-DD HH24:MI:SS.MS'),
        now()
    {{if last $idx $}}
    )
    {{else}}
    ),
    {{end}}
    {{end}}
    ON CONFLICT (api14, prod_date) DO UPDATE SET
    api10 = EXCLUDED.api10,
        prod_month_no = EXCLUDED.prod_month_no,
        liq = EXCLUDED.liq,
        gas = EXCLUDED.gas,
        wtr = EXCLUDED.wtr,
        days = EXCLUDED.days,
        cum_oil = EXCLUDED.cum_oil,
        cum_gas = EXCLUDED.cum_gas,
        cum_wtr = EXCLUDED.cum_wtr,
        entl_region = EXCLUDED.entl_region,
        entl_country = EXCLUDED.entl_country,
        entl_state = EXCLUDED.entl_state,
        entl_county = EXCLUDED.entl_county,
        entl_offshorecode = EXCLUDED.entl_offshorecode,
        is_deleted = EXCLUDED.is_deleted,
        mfg_created_at = EXCLUDED.mfg_created_at,
        mfg_deleted_at = EXCLUDED.mfg_deleted_at,
        mfg_updated_at = EXCLUDED.mfg_updated_at,
        updated_at = EXCLUDED.updated_at;