Memelang SQL Demo

SQL Query

SQL Query
`WITH z0 AS (SELECT * FROM meme m0 WHERE m0.rid="college" AND m0.bid="harvard" AND m0.qnt!=0), z1 AS (SELECT * FROM meme m0 WHERE m0.rid="college" AND m0.bid="columbia" AND m0.qnt!=0 AND m0.aid IN (SELECT aid FROM z0)) SELECT * FROM meme WHERE aid IN (SELECT aid FROM z1) UNION ALL SELECT bid AS aid, CONCAT("'", rid), aid as bid, qnt FROM meme WHERE bid IN (SELECT aid FROM z1) UNION ALL 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="college" AND m0.bid="harvard" AND m0.qnt!=0), z1 AS (SELECT * FROM meme m0  WHERE m0.rid="college" AND m0.bid="columbia" AND m0.qnt!=0 AND m0.aid IN (SELECT aid FROM z0)) SELECT * FROM meme WHERE aid IN (SELECT aid FROM z1) UNION ALL SELECT bid AS aid, CONCAT("'", rid), aid as bid, qnt FROM meme WHERE bid IN (SELECT aid FROM z1) UNION ALL SELECT * FROM z0 WHERE aid IN (SELECT aid FROM z1) UNION ALL SELECT * FROM z1;

Results
A	R	B	Q
`barack_obama`	`birth`	`barack_obama_birth`	`1`
`barack_obama`	`child`	`malia_obama`	`1`
`barack_obama`	`child`	`sasha_obama`	`1`
`barack_obama`	`college`	`columbia`	`1`
`barack_obama`	`college`	`harvard`	`1`
`barack_obama`	`college`	`occidental`	`1`
`barack_obama`	`elected`	`presidential_election_2008`	`1`
`barack_obama`	`lawyer`	`various`	`1`
`barack_obama`	`party`	`democratic`	`1`
`barack_obama`	`president_order`	`first`	`44`
`barack_obama`	`senator`	`usa`	`1`
`barack_obama`	`spouse`	`michelle_obama`	`1`
`barack_obama`	`state_senator`	`illinois`	`1`
`barack_obama`	`termlength`	`year`	`8`

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`