Google introduced new declarative language logical Programming Logica , designed to manipulate data and Translating programs in SQL. The new language is focused on those who want to use the syntax of logical programming when writing requests to the database. Currently, the resulting SQL code can be performed in the Google BigQuery repository or in the POSTGRESQL and SQLite DBMS, the support of which is still experimental. In the future, it is planned to expand the number of supported SQL dialects. The project code is written in Python and Published under the APACHE 2.0 license.
Logica continues the development of another data developed in Google. Queries in Logica are programmed in the form of a set of logical statements. Modules, import operations and the ability to use Logica from the Interactive Jupary Notebook envelope are supported.
For example, to form a summary of the people most often mentioned in the news for 2020, you can use the following program in Logica to appeal to the database Gdelt :