{"@context":"https://w3id.org/codemeta/3.0","@type":"SoftwareSourceCode","identifier":"pkg:gem/appquery?repository_url=https://gem.coop","name":"appquery","description":"Improving introspection and testability of raw SQL queries in Rails\nThis gem improves introspection and testability of raw SQL queries in Rails by:\n- ...providing a separate query-folder and easy instantiation  \n  A query like `AppQuery[:some_query]` is read from app/queries/some_query.sql.\n\n- ...providing options for rewriting a query:\n\n  Query a CTE by replacing the select:\n  query.select_all(select: \"select * from some_cte\").entries\n\n  ...similarly, query the end result (i.e. CTE `_`):\n  query.select_all(select: \"select count(*) from _\").entries\n\n- ...providing (custom) casting:  \n  AppQuery(\"select array[1,2]\").select_value(cast: true)\n\n  custom deserializers:\n  AppQuery(\"select '1' id\").select_all(cast: {\"id\" =\u003e ActiveRecord::Type::Integer.new}).entries\n\n- ...providing spec-helpers and generators\n","version":"0.8.0","softwareVersion":"0.8.0","license":"https://spdx.org/licenses/MIT","codeRepository":"https://github.com/eval/appquery","issueTracker":"https://github.com/eval/appquery/issues","url":"https://github.com/eval/appquery","programmingLanguage":{"@type":"ComputerLanguage","name":"Ruby"},"maintainer":[{"@type":"Person","name":"eval"}],"author":[{"@type":"Person","name":"eval"}],"copyrightHolder":[{"@type":"Person","name":"eval"}],"dateCreated":"2024-10-14","dateModified":"2026-01-14","datePublished":"2026-01-14","copyrightYear":2024,"downloadUrl":"https://gem.coop/downloads/appquery-0.8.0.gem","softwareHelp":{"@type":"WebSite","url":"http://www.rubydoc.info/gems/appquery/"},"applicationCategory":"rubygems","runtimePlatform":"rubygems","developmentStatus":"active","sameAs":["https://gem.coop/gems/appquery"],"funder":[{"@type":"Organization","url":"https://github.com/sponsors/eval"}],"https://www.w3.org/ns/activitystreams#likes":9}