Memelang SQL Demo

SQL Query
`WITH z0 AS (SELECT * FROM meme m0 WHERE m0.rid="president_order" AND m0.qnt>=20 AND m0.qnt<=30) SELECT * FROM meme m0 WHERE m0.rid="spouse" AND m0.qnt!=0 AND m0.aid IN (SELECT aid FROM z0) UNION ALL SELECT * FROM z0;`

Results
A	R	B	Q
`benjamin_harrison`	`spouse`	`lavinia_scott_harrison`	`1`
`calvin_coolidge`	`spouse`	`grace_anna_goodhue_coolidge`	`1`
`chester_arthur`	`spouse`	`ellen_lewis_herndon_arthur`	`1`
`grover_cleveland`	`spouse`	`frances_folsom_cleveland`	`1`
`james_garfield`	`spouse`	`lucretia_rudolph_garfield`	`1`
`theodore_roosevelt`	`spouse`	`alice_hathaway_lee_roosevelt`	`1`
`theodore_roosevelt`	`spouse`	`edith_kermit_carow`	`1`
`warren_harding`	`spouse`	`florence_kling_harding`	`1`
`william_mckinley`	`spouse`	`ida_saxton_mckinley`	`1`
`william_taft`	`spouse`	`helen_herron_taft`	`1`
`woodrow_wilson`	`spouse`	`edith_wilson`	`1`
`woodrow_wilson`	`spouse`	`ellen_louise_axson`	`1`
`james_garfield`	`president_order`	`first`	`20`
`chester_arthur`	`president_order`	`first`	`21`
`grover_cleveland`	`president_order`	`first`	`22`
`benjamin_harrison`	`president_order`	`first`	`23`
`grover_cleveland`	`president_order`	`second`	`24`
`william_mckinley`	`president_order`	`first`	`25`
`theodore_roosevelt`	`president_order`	`first`	`26`
`william_taft`	`president_order`	`first`	`27`
`woodrow_wilson`	`president_order`	`first`	`28`
`warren_harding`	`president_order`	`first`	`29`
`calvin_coolidge`	`president_order`	`first`	`30`

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`