如果JSON字段不固定，则使用Mysql查询insert

Question

我有一个与字段不一致的JSON数据

{
  "Firsthouse": {
  "Doors": "10",
  "windows": "9"
   },     

  "Secondhouse": {
  "doors": "1",
  "windows": "10",
  "pools": "2"
   } 
}

在“Secondhouse”字段中，“pools”存在，而在“Firsthouse”字段中不存在。
如果我想写一个insert查询，我是否需要有6个不同的查询来显示这些字段的存在/不存在，如下所示：

#This is a query when 3 fields are present
 query = "insert into table (doors,windows,pools) values (%s,%s,%s)"
 q_tup = data_list_3Fields
 cursor.executemany(query, q_tup)  

#This is a query when 4 fields are present
 query = "insert into table (doors,windows,pools,floors) values (%s,%s,%s,%s)"
 q_tup = data_list_4Fields
 cursor.executemany(query, q_tup)  

有没有合适的方法