CKAN DataStore SQL API from Javascript

gistfile1.js

// replace this with your CKAN website
var ckanSite = 'http://datahub.io'

var sql = 'Your SQL goes here';

// =================
// Using jQuery only
// =================

var data = encodeURIComponent(JSON.stringify({sql: sql}));

$.ajax({
  url: ckanSite + '/api/3/action/datastore_search_sql',
  type: 'POST',
  dataType: 'json',
  data: data,
  success: function(data) { console.log(data) }
});

// ==============================================================
// Using ckan.js client library - https://github.com/okfn/ckan.js
// ==============================================================

var client = new CKAN.Client(ckanSite);
client.action('datastore_search_sql', {
    sql: sql
  },
  function(err, out) {
    if (err) console.log(err);
    console.log(out);
  })
});