JSFiddle - React, Tailwind, and code Playground

by Arun Prasad 9946146920

HTML

<script src="http://alasql.org/console/alasql.min.js"></script>
    <p>SELECT * <span id="res1"></span></p>
    <p>SELECT * <span id="res2"></span></p>

JavaScript

var arrA = [{
      name: 'twitter',
      location: 0,
      hidden: false,
      href: "https://twitter.com/i/connect"
    }, {
      name: 'medium',
      location: 1,
      hidden: false,
      href: "https://medium.com/me/activity"
    }
  ];

var arrB = [{
      name: 'twitter',
      location: 1,
      hidden: false
    }, {
      name: 'medium',
      location: 0,
      hidden: false
    }
  ];

var res1 = alasql('SELECT arrA.name, arrB.location, arrA.href, arrB.hidden FROM ? arrA JOIN ? arrB USING location,', [arrA,arrB]);

alasql.fn.extend = _.extend.bind(_);
var res2 = alasql('SELECT COLUMN extend(arrA._, arrB._) FROM ? arrA JOIN ? arrB USING name', [arrA,arrB]);

document.getElementById("res1").textContent = JSON.stringify(res1);

document.getElementById("res2").textContent = JSON.stringify(res2);