title: How to convert my Sqlite tables to json array format for data storing and retrieving in Reactjs?
body: <p>I have Sqlite tables created using DB Browser for Sqlite.</p>
  <p>I implemented them for my GET/POST requests in my Reactjs project using controller.</p>
  <p>Refer here - <a href="https://github.com/CuriousDrive/EFCore.AllDatabasesConsidered/blob/main/SQLite/Steps.txt" rel="nofollow noreferrer">github</a></p>
  <p>I was able to access and store my data from the table to my React App but my table provide me data in key and
  value pairs i.e</p>
  <pre><code>{id:1 ,length:2,width:2,height:2}.
  </code></pre>
  <p>Now I want my data to be like :</p>
  <pre><code>        {
      &quot;case1&quot;: {
          &quot;type1&quot;: {
              &quot;label&quot;:[
            {&quot;label_id&quot;:&quot;1&quot;, &quot;label_name&quot;:xyz},
            {&quot;label_id&quot;:&quot;2&quot;, &quot;label_name&quot;:rty},
            {&quot;label_id&quot;:&quot;3&quot;, &quot;label_name&quot;:qwe}
         ]},
      &quot;type2&quot;: {
         &quot;label&quot;:[
          {&quot;label_id&quot;:&quot;1&quot;, &quot;label_name&quot;:xyz},
          {&quot;label_id&quot;:&quot;2&quot;, &quot;label_name&quot;:rty},
          {&quot;label_id&quot;:&quot;3&quot;, &quot;label_name&quot;:qwe}
      ]},
  }}
  </code></pre>
  <p>How to store such JSON format data to my Sqlite table and then to successfully send/retrieve the data from my React App to the server and vice-versa?</p>