Visual Query Builder

Visual Query Builder 


  I built a visual query builder for an employer that built software in the past.  Was thinking about rebuilding it using Claude Code, picking Microsoft SQL Server for the database, and making it open source.  Starts with a known database.  Dynamically pick data (tables and rows using the system view information schema).  Have interface that filters, allows summarization (sum or count) by a secondary data (table and specific row), and allows sorting (and pick ascending or descending). When picking it shows a grid that is the Preview of the data.

https://www.metabase.com/docs/latest/questions/query-builder/editor


Comments

Post a Comment

Popular posts from this blog

GHL Email Campaigns

GHL Email Campaigns Options  Option 1)    Tag free - Contacts > Quick Search box > filter data clicking to select > "Add to Automation" button > pick automation.  Option 2)   Automations > Workflows tab > pick workflow > start workflow with trigger component > click on it > pick "Contact Tag" >  "Add Filters" button > on filter add one that is "Tag Added" > pick which  type of tag. What Are The Tags 1) Settings > Tags > list of tags How to Add Tags 1) Bulk - Contacts > Quick Search box > filter data clicking to select > "Add Tag" button > pick tag 2) Single - Add tag when add contact 3) Bulk - ( Only Admin ) - In file to import, put Tags in column - Contacts > Import Contacts button > Contacts > decide columns. Everyone seems to tag the import with date AND tag it cold or hot if they can. 4) 
Read more

Free AI Tools

Free AI Tools Outbond: https://www.outbond.io/ Google AI Studio: https://aistudio.google.com/live    AI sees your screen - Excel expert Gamma: https://gamma.app/signup?r=mgp7dnjaverd8n2    visualize stuff - create sales decks  Hostinger: https://hostinger.com/wearenocode    website builder Suno: https://suno.com/    create song Leonardo AI: https://leonardo.ai/  Flow State AI  Eleven Labs: https://try.elevenlabs.io/mixajdyhxnx3  Realistic Voices.  Pauses with ...  Stress with capitalized letters. Runway AI: https://runwayml.com/   1. Animate Drawings: https://aurelius.link/meta-sketch 2. Text-to-Speech Generator: https://aurelius.link/text-to-speech-... 3. AI Headshot Generator: https://aurelius.link/headshot-generator 4. Documator: https://aurelius.link/documator 5. Free AI Transcriber: https://aurelius.link/riverside-trans... 6. Infographic Generator: https://infografix.app/ 7. Whybot: https://aurel...
Read more

Whitelabel Options

Whitelabel Options   Whitelabel is selling someone else's solution but with your own label.  So different from car dealer where the cars still are known by the original manufacturer, but more like a generic product with your brand like Walmart's "Great Value" that does not manufacture the item.  Basically you are rewrapping someone else's solution. You become a non-employee salesman, but with your own company. 1) AiFrontDesk https://www.myaifrontdesk.com/white-label Stripe Rebilling Feature Gating Website Embedding    iframe on website    route their domain to our backend GTM Advice 24/7 Technical Support Detailed Analytics They want $100/license for first 10, then $50/license for next 40 so not economically viable if only $100/mth since only $37k/year. Would have to do $200/mth or more.  Their basic is $65/mth and $50/mth if paid year up front.  So they must prefer competitors. Paige at    1 (201) 228-1089 A better deal would be "M...
Read more