GitHub - apache/datafusion: Apache DataFusion SQL Query Engine
Website | API Docs | Chat DataFusion is an extensible query engine written in Rust that uses Apache Arrow as its in-memory format. This crate provides libraries and binaries for developers building fast and feature rich database and analytic systems, customized to particular workloads. See use cases for examples. The following related subprojects target end users: DataFusion Python offers a Python
LMQL(Language Model Query Language)概観｜mah_lab / 西見 å…¬å®
LMQL Playgroundã§ã‚¯ã‚¨ãƒªã‚’試ã™LMQLã«ã¯å‹•ä½œã‚’ç°¡å˜ã«æ¤œè¨¼ã§ãã‚‹PlaygroundãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ãƒãƒ¼ã‚«ãƒ«ã§Playgroundã‚’èµ·å‹•ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ ã¾ãšã¯Getting Startedã§ç´¹ä»‹ã•ã‚Œã¦ã„る以下ã®ã‚¯ã‚¨ãƒªã‚’実行ã—ã¾ã™ã€‚ argmax "Hello[WHO]" from "openai/text-ada-001" where len(WHO) < 10「Runã€ãƒœã‚¿ãƒ³ã‚’クリックã™ã‚‹ã¨OpenAIã®API KEYを求ã‚られるã®ã§ã€å…¥åŠ›ã—ã¾ã™ã€‚ 実行ã™ã‚‹ã¨Model Responseã®æž ã«çµæžœãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ LMQLã®åŸºæœ¬æ§‹é€ LMQLã¯è¨˜æ³•çš„ã«ã¯SQLã¨ä¼¼ã¦ã„ã¦ã€ä»¥ä¸‹ã®ã‚ˆã†ãªæ§‹é€ ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ デコーダ節（Decoder Clause）： テã‚スト生æˆã«ä½¿ç”¨ã™ã‚‹ãƒ‡ã‚³ãƒ¼ãƒ‰ãƒ»ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ を指定ã—ã¾ã™ã€‚LMQLã§ã¯æ§˜ã€…ãªãƒ‡ã‚³ãƒ¼ãƒ‰ãƒ»ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚’é¸æŠžã™ã‚‹ã“ã¨ãŒã§ã
LMQL is a programming language for LLM interaction. | LMQL
LMQL is a programming language for LLMs. Robust and modular LLM prompting using types, templates, constraints and an optimizing runtime. @lmql.query def meaning_of_life(): '''lmql # top-level strings are prompts "Q: What is the answer to life, the \ universe and everything?" # generation via (constrained) variables "A: [ANSWER]" where \ len(ANSWER) < 120 and STOPS_AT(ANSWER, ".") # results are dir
Data Engineering Study #20 "Introduction to Data Analytics with SQL" Book
Data Engineering Study #20「10年戦ãˆã‚‹ãƒ‡ãƒ¼ã‚¿åˆ†æžå…¥é–€ã€å›žãƒ»å‰åŠã®ç™ºè¡¨è³‡æ–™ã§ã™ã€‚
How to Use the QUERY Function in Google Sheets
Google Sheets offers a wide range of functions to help streamline the data analysis process. One particularly useful function is the QUERY function, which allows you to extract specific information from your spreadsheet based on specified criteria or conditions. In this guide, we will explore the syntax and parameters of the QUERY function and provide examples to demonstrate how you can use QUERY
CTEs(Common Table Expressions)ã«ã¤ã„ã¦å¦ã³ç›´ã™
本記事ã¯BigQuery Advent Calendar 2022ã«å¯„稿ã—ãŸè¨˜äº‹ã¨ãªã‚Šã¾ã™ã€‚ 17日目ã¯BigQueryã«ç›´æŽ¥é–¢ã™ã‚‹å†…容ã§ã¯ãªãã€BigQueryã§å–り扱ã†SQLã®æ§‹æˆã«ã¤ã„ã¦èªžã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ☕ï¸Ice Break Who are you? / ãŠå‰ã¯ä½•è€…ã ？ åˆã‚ã¾ã—ã¦ã®æ–¹ã¯åˆã‚ã¾ã—ã¦ã€‚ã”å˜çŸ¥ã®æ–¹ã¯ãŠä¹…ã—ã¶ã‚Šã§ã™ã€‚ @kazuya_araki_jpã¨ç”³ã—ã¾ã™ã€‚事æ¥ä¼šç¤¾ã§ãƒ‡ãƒ¼ã‚¿é–¢é€£ã®è·ã«å°±ã„ã¦ã„る者ã§ã™ã€‚ 詳細ã¯noteã®æ–¹ãŒè©³ã—ã„ã®ã§ãã¡ã‚‰ã‚’ã”覧ãã ã•ã„。 Recent state / 最近何ã—ã¦ã„る？ 本æ¥ãŒï¾„ｯﾃﾓﾄｯﾃﾓｲｿｶﾞｼｶｯﾀYO! 法人準備ä¸ã€‚ Splatoon 3 Introduction / å°Žå…¥ ã“ã“最近ã«é™ã‚‰ãšã§ã™ãŒã€BigQueryを扱ã†ä¸Šã§SQLã®æ›¸ãæ–¹ã«æ‚©ã¿ç¶šã‘ã¦ã„ã¾ã™ã€‚ ã¨ã„ã†ã®ã‚‚ã€å¤§æ˜”(å°‘ãªãã¨ã‚‚ç§ãŒSQLãŠã‚ˆã³ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’知
GitHub - sqlfluff/sqlfluff: A modular SQL linter and auto-formatter with support for multiple dialects and templated code.
Although SQL is reasonably consistent in its implementations, there are several different dialects available with variations of syntax and grammar. SQLFluff currently supports the following SQL dialects (though perhaps not in full): ANSI SQL - this is the base version and on occasion may not strictly follow the ANSI/ISO SQL definition Athena BigQuery ClickHouse Databricks (note: this extends the s
ã¾ã PostgreSQL ã®é–‹ç™ºã§ç–²å¼Šã—ã¦ã‚‹ã®ï¼Ÿ - Qiita
{ "plpgsqlLanguageServer.database": "データベースå", "plpgsqlLanguageServer.user": "ユーザå", "plpgsqlLanguageServer.password": "パスワード", "plpgsqlLanguageServer.definitionFiles": [ // glob をサãƒãƒ¼ãƒˆã€‚ "**/*.sql", "**/*.psql", "**/*.pgsql" ], // Language Server ãŒå¯¾å¿œã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã®æ‹¡å¼µåã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ ['*.pgsql', '*.psql'] ã§ã™ã€‚ // （ SQLite ãªã©ä»–ã® RDS ã¨ç«¶åˆã•ã›ãªã„ãŸã‚ã§ã™ã€‚） // '*.sql' ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚‚対応ã•ã›ãŸã„å ´åˆã¯ã€ä¸‹è¨˜ã®è¨å®šã‚’è¿½åŠ ã—ã¦ãã ã•ã„。 "files.associations": { "*.sq
ワンライナー㧠CSV ã«å¯¾ã—㦠SQLite クエリを実行ã™ã‚‹ - アルパカã®å¾’然文
One-liner for running queries against CSV files with SQLite ã¨ã„ã†è¨˜äº‹ã§ç´¹ä»‹ã•ã‚Œã¦ã„ãŸã€ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã‚’使ã£ã¦ CSV ファイルã«å¯¾ã—㦠SQL クエリを実行ã™ã‚‹æ–¹æ³•ã€‚ $ sqlite3 :memory: -cmd '.mode csv' -cmd '.import taxi.csv taxi' \ 'SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi GROUP BY passenger_count' ソース元ã«è¨˜è¿°ã•ã‚Œã¦ã‚‹é€šã‚Šã€taxi.csv ã‚’ GitHub ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦è©¦ã™ã“ã¨ãŒã§ãる。7z ã§åœ§ç¸®ã•ã‚Œã¦ã„ã¦è§£å‡ã™ã‚‹å¿…è¦ãŒã‚る。 SQLite ã¯é€šå¸¸ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ‡ã‚£ã‚¹ã‚¯ï¼ˆSSD ã¨ã‹ï¼‰ä¸Šã«ä¿å˜ã—ã¦åˆ©ç”¨ã™ã‚‹ã®ãŒä¸€èˆ¬çš„ã ãŒã€SQLite å´ã§ç”¨æ„ã•
SQL Performance Explained - buy directly from the author with free delivery
A Book For DevelopersSQL performance books are tomes. Hundreds of pages filled with knowledge… …not relevant to developers. SQL Performance Explained focuses on what developers need to know. Just 200 pages… …yet covering all major databases. (PayPal, global free shipping) Remove Paperback also available at Amazon.com. (paperback only, paid link) “This is the best book on indexes that currently exi
DBスã‚ーマ変更管ç†ãƒ„ール sqldef を試ã—ã¦ã¿ãŸ - Qiita
1. sqldef ã¨ã¯ sqldef 㯠"The easiest idempotent MySQL/PostgreSQL/SQLite3/SQL Server schema management by SQL." ã¨è¬³ã£ã¦ã„ã‚‹DBスã‚ーマ変更管ç†ãƒ„ールã§ã™ã€‚ 通常ã®é–‹ç™ºã«ãŠã„㦠DDL 文を管ç†ã™ã‚‹å ´åˆã€ç’°å¢ƒã‚’１ã‹ã‚‰ä½œã‚‹ã‚ˆã†ã« CREATE TABLE æ–‡ãªã©æ–°è¦ä½œæˆ DDL 文を準備ã™ã‚‹ã¨å…±ã«ã€æ—¢ã«ä½œæˆæ¸ˆã¿ã®ç’°å¢ƒã§ãƒ†ãƒ¼ãƒ–ルを変更ã™ã‚‹ãŸã‚ã« ALTER TABLE æ–‡ãªã©å·®åˆ†é©ç”¨ DDL 文を準備ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ï¼’種類㮠DDL 文を二é‡ç®¡ç†ã—ãªã„ã¨ã„ã‘ãªã„ã¨ã„ã†ã®ã¯ DBA ã«ã¨ã£ã¦ã¯é ã®æ‚©ã¾ã—ã„å•é¡Œã§ã—ãŸã€‚（差分é©ç”¨ DDL æ–‡ã®ã¿æº–å‚™ã—ã€ï¼‘ã‹ã‚‰ç’°å¢ƒã‚’ä½œã‚‹å ´åˆã‚‚å…¨ã¦ã®å¤‰æ›´ã‚’é©ç”¨ã™ã‚‹ã¨ã„ã†æ‰‹ã‚‚ã‚ã‚Šã¾ã™ãŒâ€¦ï¼‰ sqldef を利用ã™ã‚‹ã¨ã€å¤‰æ›´é©ç”¨å…ˆ DB ã®ç¾åœ¨ã®çŠ¶æ³ã¨æ–°è¦ä½œæˆ
Working with JSON data in GoogleSQL  | BigQuery  | Google Cloud
Send feedback Stay organized with collections Save and categorize content based on your preferences. Working with JSON data in GoogleSQL This document describes how to create a table with a JSON column, insert JSON data into a BigQuery table, and query JSON data. BigQuery natively supports JSON data using the JSON data type. JSON is a widely used format that allows for semi-structured data, becaus
pingcap/parser (MySQL互æ›) 㧠SQL を手軽ã«è§£æž - freee Developers Hub
ã“ã®è¨˜äº‹ã¯ freee Developers Advent Calendar 2021 ã®23日目ã®è¨˜äº‹ã§ã™ðŸŽ„ freee ã® DBRE ãƒãƒ¼ãƒ ã«æ‰€å±žã—ã¦ã„ã‚‹ caterpillar ã§ã™. ãªã‚“ã ã‹å¤§ããªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’眺ã‚る仕事をã—ã¦ã„ã¾ã™. çªç„¶ã§ã™ãŒ, pingcap/parser を使ã£ã¦ SQL ã‚’ç°¡å˜ã«è§£æžã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™. Go 製 ã® SQL Parser ã§, MySQL ã¸ã®é«˜ã„互æ›æ€§ã‚’謳ㆠTiDB ã§åˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™. ã“ã® parser ã®å¬‰ã—ã„点ã¯ã“ã‚“ãªæ„Ÿã˜ã§ã™. シンプルã§ä½¿ã„ã‚„ã™ã„ TiDB ã«åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã“ã¨ã‹ã‚‰, ã‚る程度çµæžœã‚’ä¿¡é ¼ã§ãã‚‹ mask 済 SQL ã‚‚ãŠãŠã‚ˆã構文解æžå¯èƒ½ 3ã¤ç›®ã«ã¤ã„ã¦, mask済㮠SQL 㯠select * from users where id = ? ã®ã‚ˆã†ã«ä¸€éƒ¨ãŒåˆ¥ã®æ–‡å—ã«ç½®ãæ›ã‚ã£ã¦ã„ã‚‹ã‚‚ã®ã‚’指ã—ã¾
メンテナンス
ãŠçŸ¥ã‚‰ã›
障害
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
GitHub - timvw/qv: Quickly view your data
GitHub - dask-contrib/dask-sql: Distributed SQL Engine in Python using Dask
DB Pilot - DuckDB GUI Client
GitHub - eth-sri/lmql: A language for constraint-guided and efficient LLM programming.
Create an advanced search engine with PostgreSQL
GitHub - sqlc-dev/sqlc: Generate type-safe code from SQL
GitHub - reata/sqllineage: SQL Lineage Analysis Tool powered by Python
{{#tags}}- {{label}}
{{/tags}}