SQLite
дистанционно
договорная
Решить задачу. Есть таблица my_table в SQLite (v_3.27.2), в ней есть 2 поля в формате JSON в которых нужные мне данные: Поле Data, нужно вытащить первую и вторую строку metrics и сделать их в виде столбцов: [{"dimensions": [{"icon_id": "3", "icon_type": "traffic-source", "name": "Ad traffic", "id": "ad"}], "metrics": [[174.0, 103.0, 77.0, 42.0, 54.0, 81.0, 140.0, 235.0, 438.0, 557.0, 688.0, 708.0, 669.0, 612.0, 688.0, 675.0, 933.0, 1015.0, 998.0, 834.0, 861.0, 658.0, 617.0, 414.0]]}, {"dimensions": [{"icon_id": "2", "icon_type": "traffic-source", "name": "Search engine traffic", "id": "organic"}], "metrics": [[76.0, 60.0, 50.0, 41.0, 39.0, 59.0, 84.0, 104.0, 142.0, 186.0, 177.0, 215.0, 169.0, 197.0, 186.0, 170.0, 161.0, 178.0, 200.0, 185.0, 195.0, 196.0, 164.0, 148.0]]}, {"dimensions": [{"icon_id": "0", "icon_type": "traffic-source", "name": "Direct traffic", "id": "direct"}], "metrics": [[5.0, 7.0, 5.0, 5.0, 4.0, 1.0, 6.0, 7.0, 7.0, 18.0, 15.0, 17.0, 14.0, 15.0, 13.0, 13.0, 17.0, 18.0, 16.0, 15.0, 12.0, 7.0, 15.0, 6.0]]}, {"dimensions": [{"icon_id": "1", "icon_type": "traffic-source", "name": "Link traffic", "id": "referral"}], "metrics": [[1.0, 2.0, 1.0, 6.0, 2.0, 0.0, 3.0, 0.0, 5.0, 3.0, 5.0, 5.0, 6.0, 4.0, 5.0, 2.0, 5.0, 3.0, 11.0, 3.0, 3.0, 2.0, 5.0, 2.0]]}, {"dimensions": [{"icon_id": "-1", "icon_type": "traffic-source", "name": "Internal traffic", "id": "internal"}], "metrics": [[3.0, 1.0, 2.0, 2.0, 1.0, 0.0, 0.0, 1.0, 6.0, 4.0, 5.0, 5.0, 2.0, 4.0, 4.0, 1.0, 8.0, 4.0, 2.0, 8.0, 5.0, 1.0, 3.0, 0.0]]}, {"dimensions": [{"icon_id": "10", "icon_type": "traffic-source", "name": "Messenger traffic", "id": "messenger"}], "metrics": [[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 1.0, 1.0, 0.0, 0.0, 0.0, 0.0, 0.0, 1.0, 0.0, 1.0, 0.0, 0.0, 0.0]]}, {"dimensions": [{"icon_id": "9", "icon_type": "traffic-source", "name": "Recommendation system traffic", "id": "recommend"}], "metrics": [[0.0, 0.0, 1.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0]]}] Поле Time_intervals, вытащить даты в два столбца рядом с metrics: [["2023-05-21 00:00:00", "2023-05-21 00:59:59"], ["2023-05-21 01:00:00", "2023-05-21 01:59:59"], ["2023-05-21 02:00:00", "2023-05-21 02:59:59"], ["2023-05-21 03:00:00", "2023-05-21 03:59:59"], ["2023-05-21 04:00:00", "2023-05-21 04:59:59"], ["2023-05-21 05:00:00", "2023-05-21 05:59:59"], ["2023-05-21 06:00:00", "2023-05-21 06:59:59"], ["2023-05-21 07:00:00", "2023-05-21 07:59:59"], ["2023-05-21 08:00:00", "2023-05-21 08:59:59"], ["2023-05-21 09:00:00", "2023-05-21 09:59:59"], ["2023-05-21 10:00:00", "2023-05-21 10:59:59"], ["2023-05-21 11:00:00", "2023-05-21 11:59:59"], ["2023-05-21 12:00:00", "2023-05-21 12:59:59"], ["2023-05-21 13:00:00", "2023-05-21 13:59:59"], ["2023-05-21 14:00:00", "2023-05-21 14:59:59"], ["2023-05-21 15:00:00", "2023-05-21 15:59:59"], ["2023-05-21 16:00:00", "2023-05-21 16:59:59"], ["2023-05-21 17:00:00", "2023-05-21 17:59:59"], ["2023-05-21 18:00:00", "2023-05-21 18:59:59"], ["2023-05-21 19:00:00", "2023-05-21 19:59:59"], ["2023-05-21 20:00:00", "2023-05-21 20:59:59"], ["2023-05-21 21:00:00", "2023-05-21 21:59:59"], ["2023-05-21 22:00:00", "2023-05-21 22:59:59"], ["2023-05-21 23:00:00", "2023-05-21 23:59:59"]] Нашел вариант каждый элемент отдельно доставать, но это не поможет при увеличении периода.