SqlTools is a collection of tools for working with SQL ASTs. It's the intersection of ruby_tree_sitter & tree-sitter-sql, letting you parse SQL queries and transform them into semantic Ruby objects.
If you're having trouble installing ruby_tree_sitter try installing the libraries for the latest supported version of
libtree-sitter.
git clone https://github.com/tree-sitter/tree-sitter
cd tree-sitter
git checkout tags/v0.22.6
make
sudo make install
To install the SQL parser run the rake task.
bundle exec rake treesitter:install
SqlTools.query_from_sql(<<~SQL)
SELECT id, name
FROM table_a
WHERE id > 10
AND id < 20
SQL
After checking out the repo, run bin/setup to install dependencies. You can also run bin/console for an interactive prompt that will allow you to experiment.
Bug reports and pull requests are welcome on GitHub at https://github.com/DerekStride/sql_tools. This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the code of conduct.
The gem is available as open source under the terms of the MIT License.
Everyone interacting in the SqlTools project's codebases, issue trackers, chat rooms and mailing lists is expected to follow the code of conduct.
FAQs
Unknown package
We found that sql_tools demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
PyPI confirms no security flaws were exploited in the Ultralytics supply chain attack and highlights improvements for safer package publishing.
Security News
Research
The Socket Research Team breaks down a malicious wrapper package that uses obfuscation to harvest credentials and exfiltrate sensitive data.
Research
Security News
Attackers used a malicious npm package typosquatting a popular ESLint plugin to steal sensitive data, execute commands, and exploit developer systems.