ALASQL

HTML

<script src="https://cdnjs.cloudflare.com/ajax/libs/alasql/0.3.2/alasql.min.js"></script>

Babel + JSX

const users =  [{UserId: '1', UserName: 'User'}]
const orders = [{UserId: '1', Text: 'Order text'}]

const expected = alasql(`
	SELECT *
  FROM ? u 
  JOIN ? o 
  ON u.UserId = o.UserId`, 
  [users, orders])

const unexpected = alasql(`
	SELECT UserName,Text 
  FROM ? u 
  JOIN ? o 
  ON u.UserId = o.UserId`, 
  [users, orders])
  
console.log({expected, unexpected}); 
// {
//   expected: [{
//     Text: "Order text",
//     UserId: "1",
//     UserName: "User"
// }],
//   unexpected: [{
//     Text: undefined,
//     UserName: "User"
//   }]
// }