JSON to SQL DDL

Your json

{

"countries": [

{

"name": "USA",

"id": 2,

"population": 350

{

"name": "Germany",

"id": 5,

"population": 80

{

"name": "Japan",

"id": 9,

"population": 140

}

]

}

CREATE TABLE generic (
  id TEXT,
  PRIMARY KEY (id)
);

CREATE TABLE generic_countries (
  generic_id TEXT,
  name TEXT,
  id INT,
  population INT,
  PRIMARY KEY (id),
  FOREIGN KEY (generic_id) REFERENCES generic(id)
);