SQL validator tool for BigQuery standard SQL.

Last update: Dec 25, 2022

Related tags

Database bqvalid

Overview

bqvalid

What bqvalid does

bqvalid is the SQL validator tool for BigQuery standard SQL. bqvalid fails with error message if there's the expression that will cause full scan, print as it is otherwise.

Usage

cat sample.sql | bqvalid

If the SQL is contained the expressions that comparing ``_TABLE_SUFFIXwith subquery,bqvalid` outputs the reason and its position like:

5:7: Full scan will cause! Should not compare _TABLE_SUFFIX with subquery

Also, you can input file paths or directory. bqvalid collects files whose extension is .sql (ignores files that has other extensions) :

bqvalid one.sql two.sql three.sql

bqvalid sql/

Then, the output will as follows:

one.sql:6:6: Full scan will cause! Should not compare _TABLE_SUFFIX with subquery
three.sql:5:19: Full scan will cause! Should not compare _TABLE_SUFFIX with subquery

Fully typed SQL query builder for Rust [deprecated]

What is Deuterium? Deuterium is a fancy SQL builder for Rust. It's designed to provide a DSL to easily build SQL queries in safe and typed way. Like R

169 Nov 20, 2022

Ormlite - An ORM in Rust for developers that love SQL.

ormlite ormlite is an ORM in Rust for developers that love SQL. It provides the following, while staying close to SQL, both in syntax and performance:

28 Jan 1, 2023

Distributed SQL database in Rust, written as a learning project

toyDB Distributed SQL database in Rust, written as a learning project. Most components are built from scratch, including: Raft-based distributed conse

4.6k Jan 8, 2023

Distributed, version controlled, SQL database with cryptographically verifiable storage, queries and results. Think git for postgres.

SDB - SignatureDB Distributed, version controlled, SQL database with cryptographically verifiable storage, queries and results. Think git for postgres

5 Apr 26, 2022

X-Engine: A SQL Engine built from scratch in Rust.

XNGIN (pronounced "X Engine") This is a personal project to build a SQL engine from scratch. The project name is inspired by Nginx, which is a very po

111 Dec 15, 2022

Rust library to parse, deparse and normalize SQL queries using the PostgreSQL query parser

This Rust library uses the actual PostgreSQL server source to parse SQL queries and return the internal PostgreSQL parse tree.

37 Dec 18, 2022

RisingWave is a cloud-native streaming database that uses SQL as the interface language.

RisingWave is a cloud-native streaming database that uses SQL as the interface language. It is designed to reduce the complexity and cost of building real-time applications. RisingWave consumes streaming data, performs continuous queries, and updates results dynamically. As a database system, RisingWave maintains results inside its own storage and allows users to access data efficiently.

3.7k Jan 2, 2023

Type-safe SQL query wrappers

fnsql The fnsql crate provides simple type-safe optional wrappers around SQL queries. Instead of calling type-less .query() and .execute(), you call

9 Apr 29, 2022

A Toy Query Engine & SQL interface

Naive Query Engine (Toy for Learning) 😄 This is a Query Engine which support SQL interface. And it is only a Toy for learn query engine only. You can

45 Dec 21, 2022

Comments

proposal: read file from arguments
Currently, bqvalid parse only sql from stdin. But, I think the following usage is ordinary.

bqvalid <FILE_PATH> # search *.sql in subdirectory bqvalid <DIR_PATH>
opened by kitagry 3
Change columns and rows to 1-based

Most of linters use 1-based value for row and col. But, tree-sitter use 0-based rows and cols.

https://docs.rs/tree-sitter/latest/tree_sitter/struct.Point.html

opened by kitagry 2
More parsable format
I think parsable error format is important to use some useful tools ex) reviewdog For example,

$ golint comment_iowriter.go:11:6: exported type CommentWriter should have comment or be unexported

I want some option which change error format, or default format should be changed. If you like this idea, I'll create PR.
opened by kitagry 1

Check subdirectories

relate #6

❯ cargo run -- .
./sql/subquery_with_binary_op.sql:5:19: Full scan will cause! Should not compare _TABLE_SUFFIX with subquery
./sql/subquery_with_between.sql:6:6: Full scan will cause! Should not compare _TABLE_SUFFIX with subquery
./sql/subquery_with_between_from.sql:5:24: Full scan will cause! Should not compare _TABLE_SUFFIX with subquery
./sql/subquery_with_between_to.sql:6:6: Full scan will cause! Should not compare _TABLE_SUFFIX with subquery

opened by kitagry 0