Logica: Declarative Data Science for Mere Mortals

Logica (= Logic + aggregation) is a freely available, open-source, feature-enhanced version of Datalog that automatically compiles logic rules to several SQL platforms, i.e., a lightweight, serverless SQLite engine, a multi-user client-server PostgreSQL system, and a highly scalable, parallel BigQuery instance. Logica combines the beginner-friendly declarative features of Datalog (intuitive, pattern-based queries in the style of QBE), with advanced analytical features needed by data science practitioners when processing large, real-world datasets. The system has been used for data science applications and training in industry, and in graduate-level courses in academia. Logica allows beginners to seamlessly progress from traditional (toy) examples to intermediate and advanced use cases.