Memelang SQL Demo

SQL Query

SQL Query
`WITH z0 AS (SELECT * FROM meme m0 WHERE m0.rid="occupation" AND m0.bid="lawyer" AND m0.qnt!=0), z1 AS (SELECT * FROM meme m0 WHERE m0.rid="college" AND m0.bid="harvard" AND m0.qnt=1 AND m0.aid IN (SELECT aid FROM z0) UNION ALL SELECT * FROM meme m0 WHERE m0.rid="college" AND m0.bid="william_and_mary" AND m0.qnt=1 AND m0.aid IN (SELECT aid FROM z0)) SELECT * FROM z0 WHERE aid IN (SELECT aid FROM z1) UNION ALL SELECT * FROM z1;`

WITH z0 AS (SELECT * FROM meme m0  WHERE m0.rid="occupation" AND m0.bid="lawyer" AND m0.qnt!=0), z1 AS (SELECT * FROM meme m0  WHERE m0.rid="college" AND m0.bid="harvard" AND m0.qnt=1 AND m0.aid IN (SELECT aid FROM z0) UNION ALL SELECT * FROM meme m0  WHERE m0.rid="college" AND m0.bid="william_and_mary" AND m0.qnt=1 AND m0.aid IN (SELECT aid FROM z0)) SELECT * FROM z0 WHERE aid IN (SELECT aid FROM z1) UNION ALL SELECT * FROM z1;

Results
A	R	B	Q

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

Show all data in this DB.
`qry.all`
All about George Washington.
`george_washington`
Who were children of the presidents?
`.child`
Which presidents were members of the Whig party?
`.party:whig`
Which presidents attended Harvard?
`.college:harvard`
Which presidents were born before 1820?
`.birth.year:ad<1820`
Which presidents attended Columbia and were lawyers?
`.college:columbia .lawyer`
Who were the twentieth through thirtieth presidents?
`.president_order>=20 .president_order<=30`
Which presidents attended a college that was not Harvard?
`.college .college:harvard=f`
Which presidents did not have children?
`.president_order .child=f`
Who were the spouses of the twentieth through thirtieth presidents?
`.president_order>=20 .president_order<=30 .spouse`
Use qry.all to return all memes related to the matching As.
`.college:harvard .college:columbia qry.all`
Get all about James Carter as well as Ronald Reagan.
`james_carter; ronald_reagan`
Which presidents were lawyers that attended Harvard or William and Mary?
`.lawyer .college:harvard=t1 .college:william_and_mary=t1`
What were the professions of the presidents?
`?profession`
Which presidents has children that became presidents?
`.child.president_order`