> Please somebody combine APL with SQL and you win the programming language wars.
kdb+ and q fit this description. Docs here: https://code.kx.com/q/basics/qsql/
Here's an example.
In SQL:
SELECT stock, SUM(amount) AS total FROM trade GROUP BY stock
In q: q)select total:sum amt by stock from trade