Google ya gabatar da sabon yaren shirye-shiryen dabaru, Logica, wanda aka tsara don sarrafa bayanai da fassara shirye-shirye zuwa SQL. Sabon harshen yana nufin waɗanda ke son yin amfani da tsarin tsara dabaru lokacin rubuta tambayoyin bayanai. A halin yanzu, za a iya aiwatar da lambar SQL da aka samu a cikin ma'ajin Google BigQuery ko a cikin PostgreSQL da SQLite DBMSs, goyon bayan wanda har yanzu gwaji ne. A nan gaba ana shirin faɗaɗa adadin yarukan SQL masu tallafi. An rubuta lambar aikin a cikin Python kuma an buga shi ƙarƙashin lasisin Apache 2.0.
Logica ya ci gaba da haɓaka wani yaren sarrafa bayanai da Google ya haɓaka, Yedalog, kuma yana ba da matakin abstraction da ba a samu a daidaitaccen SQL ba. Tambayoyi a cikin Logica an tsara su a cikin nau'i na maganganun ma'ana. Yana goyan bayan kayayyaki, shigo da kaya, da ikon amfani da Logica daga harsashi na Jupyter Notebook. Misali, don samar da taƙaitaccen mutanen da aka fi ambata a cikin labarai na 2020, kuna iya amfani da shirin Logica mai zuwa don samun damar bayanan GDELT: @OrderBy(Mentions, “menions desc”); @Limit (Ambaton, 10); ambaton (mutum:, ya ambaci? += 1) bambanta:- gdelt-bq.gdeltv2.gkg (mutane:, kwanan wata:), Substr (ToString (kwanan wata), 0, 4) == "2020", da_mutane == Rarraba (mutane, ";"), mutum a cikin_mutane; $ logica ambaci.l gudu Abubuwan ambato +—————-+—————-+ | mutum | ambaton_count | +—————-+—————-+ | Donald trump | 3077130 | | ma'ana | 1078412 | | joe biden | 1054827 | | george floyd | 872919 | | boris johnson | 674786 | | Barack Obama | 438181 | | vladimir putin | 410587 | | bernie Sanders | 387383 | | Andrew cuomo | 345462 | | las vegas | 325487 | +————————————-+
Rubutun hadaddun tambayoyin a cikin SQL yana haifar da buƙatar rubuta sarƙoƙi masu sarƙaƙƙiya waɗanda ba a bayyane suke ba don fahimta, tsoma baki tare da sake amfani da sassan tambayar, da rikitar da kulawa. Don ƙididdige ƙididdiga na yau da kullun, SQL na iya amfani da ra'ayoyi da ayyuka, amma ba sa tallafawa ayyukan shigo da kaya kuma ba sa samar da sassaucin manyan harsuna (misali, ba za ku iya wuce aiki zuwa aiki ba). Logica yana ba ku damar tsara shirye-shirye daga ƙanana, masu fahimta, da tubalan ma'ana waɗanda za a iya gwada su, hade da takamaiman sunaye, da kuma haɗa su cikin fakiti waɗanda za a iya amfani da su azaman ɓangare na sauran ayyukan.
source: budenet.ru