SELECT "tv_smartdevicemeasurement_modbus"."measurement_id", "tv_smartdevicemeasurement_modbus"."smart_device_id", "tv_smartdevicemeasurement_modbus"."parent_job_id", "tv_smartdevicemeasurement_modbus"."insert_time", "tv_smartdevicemeasurement_modbus"."data", (SELECT data->> 'QL1') AS "subset_data" FROM "tv_smartdevicemeasurement_modbus" WHERE ("tv_smartdevicemeasurement_modbus"."insert_time" > '2019-02-04T12:46:00+01:00'::timestamptz AND "tv_smartdevicemeasurement_modbus"."insert_time" < '2019-02-04T13:02:00+01:00'::timestamptz AND "tv_smartdevicemeasurement_modbus"."smart_device_id" = 1)