- Notifications
You must be signed in to change notification settings - Fork93
GitQL is a extensible SQL-like query language and SDK to perform queries on various data sources such .git files with supports of most of SQL features such as grouping, ordering and aggregation and window functions and allow customization like user-defined types and functions
License
AmrDeveloper/GQL
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
GitQL is a tool that built using the GitQL SDk to perform SQL like query on your local .git files
GitQL SDK is an in memory query engine implemented from scratch as a set of libraries that allow you to perform high customization in types, schema, data provider, operators and functions, so you can build your own tool to run SQL like query on any kind of data.
Note that all Keywords in GitQL are case-insensitive, similar to SQL.
SELECT1SELECT1+2SELECT LEN("Git Query Language")SELECT"One"IN ("One","Two","Three")SELECT"Git Query Language"LIKE"%Query%"SELECT INTERVAL'1 year 2 mons 3 days 04:05:06.789'SET @arr= [1,2,3];SELECT [[1,2,3], [4,5,6], [7,8,9]];SELECT @arr[1], @arr[2], @arr[3], ARRAY_LENGTH(@arr);SELECT @arr[1:2], @arr[2:], @arr[:2];SELECT DISTINCT titleAS ttFROM commitsSELECT author_name,COUNT(author_name)AS commit_numFROM commitsGROUP BY author_name, author_emailORDER BY commit_numDESCLIMIT10SELECT commit_countFROM branchesWHERE commit_count BETWEEN0AND10SELECT*FROM refsWHERE type="branch"SELECT*FROM refsORDER BY typeSELECT*FROM commitsSELECT author_name, author_emailFROM commitsSELECT author_name, author_emailFROM commitsORDER BY author_nameDESC, author_emailASCSELECT author_name, author_emailFROM commitsWHERE author_emailLIKE"%gmail%"ORDER BY author_nameSELECT*FROM commitsWHERELOWER(author_name)="AmrDeveloper"SELECT author_nameFROM commitsGROUP By author_nameSELECT author_nameFROM commitsGROUP By author_nameHAVING author_name="AmrDeveloper"SELECT*FROM branchesSELECT*FROM branchesWHERE is_head= trueSELECT name, LEN(name)FROM branchesSELECT*FROM tagsSELECT*FROM tags OFFSET1LIMIT1SELECTpath,count()AS changes_count,SUM(insertions)AS additions,SUM(removals)AS removesFROM diffs_changesGROUP BYpathORDER BY changes_countDESC
- Full Documentation
- Install or Build
- Tables
- Types
- Statements
- Expressions
- Functions and Operators
- Aggregations
- GitQL SDK
- Customize the Data Schema.
- Customize the Data Provider.
- Customize the Standard library.
- Customize the Type system.
- Customize the Value system.
- Connect Components together.
- LLQL:Tool to run SQL query on LLVM IR/BC and perform Pattern matching on instructions.
- ClangQL:Tool to run SQL query on C/C++ Source code files.
- FileQLTool to run SQL query on file systems and extract metadata.
- PyQLTool to run SQL query on Python Source code files.
MIT LicenseCopyright (c) 2023 - 2025 Amr HeshamPermission is hereby granted, free of charge, to any person obtaining a copyof this software and associated documentation files (the "Software"), to dealin the Software without restriction, including without limitation the rightsto use, copy, modify, merge, publish, distribute, sublicense, and/or sellcopies of the Software, and to permit persons to whom the Software isfurnished to do so, subject to the following conditions:The above copyright notice and this permission notice shall be included in allcopies or substantial portions of the Software.THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS ORIMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THEAUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHERLIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THESOFTWARE.
About
GitQL is a extensible SQL-like query language and SDK to perform queries on various data sources such .git files with supports of most of SQL features such as grouping, ordering and aggregation and window functions and allow customization like user-defined types and functions