select a1, a2 * 10 where a1 == "Buy" && a4.indexOf('oil') != -1 order by parseInt(a2), a4 limit 100
Combination of SQL statements and expressions from a different language makes RBQL very easy to learn and use: you just need basic understanding of SQL and one of the available general-purpose backend languages. So there is a high chance that you alread know RBQL!
Use the default test table below (reduced version of kaggle imdb-5000) or "upload" your own. Your data is safe: selected table doesn't actualy get uploaded anywhere - all operations are performed locally in the browser. Every query result is a first-class table.
Select spreadsheet file to use. Your data is safe: the file won't be sent over network - all operations are performed locally in the browser. Performance of this demo is limited by your browser rendering capabilities - do not submit very big files!
2. Choose file separator character:
Input SQL-like RBQL query and press Enter. Use a1, a2, a3, ... and NR as column names.