Results

Code

Memelang:  ?profession

SQL:  SELECT m0.aid as aid, CONCAT(m0.rid, ' ', CONCAT("?", m1.rid)) AS rid, CONCAT(m0.bid, ' ', m1.bid) AS bid, CONCAT(m0.qnt, ' ', m1.qnt) AS qnt FROM meme m0 JOIN meme m1 ON m0.rid=m1.aid WHERE m1.rid="profession" AND m0.qnt!=0 AND m1.qnt!=0;

Memelang Demo

This is demonstration of translating Memelang to SQL for querying relational databases. See the PHP code in GitHub. A Python implementation is coming soon. Example queries:

Show all data in the database.

All about George Washington.

Who were children of the presidents?

Which presidents were members of the Whig party?

Which presidents were born before 1820?

Which presidents attended Columbia and were lawyers?

Who were the spouses of the twentieth through thirtieth presidents?

Which presidents did not have children?

Use qry.all to return all memes related to the matching As.

Get all about James Carter as well as Ronald Reagan.

Which presidents were lawyers that attended Harvard or William and Mary?

What were the professions of the presidents?

What were the professions of George Washington?

Which presidents previously worked for New York state?

Which presidents has children that became presidents?