Memelang SQL Demo

Results

A	R	B	Q
`benjamin_harrison`	`president_order`	`first`	`23`
`calvin_coolidge`	`president_order`	`first`	`30`
`chester_arthur`	`president_order`	`first`	`21`
`grover_cleveland`	`president_order`	`first`	`22`
`grover_cleveland`	`president_order`	`second`	`24`
`james_garfield`	`president_order`	`first`	`20`
`theodore_roosevelt`	`president_order`	`first`	`26`
`warren_harding`	`president_order`	`first`	`29`
`william_mckinley`	`president_order`	`first`	`25`
`william_taft`	`president_order`	`first`	`27`
`woodrow_wilson`	`president_order`	`first`	`28`
`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`

Code

Memelang: .president_order>=20 .president_order<=30 .spouse

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

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:

Results

Code

Memelang Demo

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?