Results for “suiteql”

Optimize SQL queries, indexes, and database performance across MySQL, PostgreSQL, SQL Server, and Oracle with execution plan analysis and universal tuning techniques.

Kysely type-safe SQL query builder - End-to-end type safety from schema to queries, migrations, transactions, plugins

Guidelines for developing with Kysely, a type-safe TypeScript SQL query builder with autocompletion support

Maps the Salesforce CPQ managed-package object graph (SBQQ__ namespace) and explains when to use the CPQ Quote API for programmatic writes instead of direct DML.

Analiza datos en bases de datos relacionales con consultas SQL eficientes y legibles, incluyendo joins, window functions, CTEs y subqueries, para extraer insights directamente de la base de datos.

SQL injection occurs when untrusted user input is interpolated directly into database queries, allowing attackers to alter query logic. Detect via single-quote errors, boolean-based blind responses (AND 1=1 vs AND 1=2), time-delay payloads (SLEEP, WAITFOR), UNION column enumeration, and error messages from MySQL, Oracle, MSSQL, PostgreSQL. Tools: sqlmap, sqlbftools, Burp Suite, wfuzz with SQLi fuzz strings.

Optimizes SQL queries with execution plan analysis, index suggestions, and query rewriting

Write and debug SOQL queries covering SELECT syntax, filters, sorting, pagination, relationship traversal, and aggregate functions.

Deploy SQL Scripts to a Fabric Warehouse

You are an expert in urql, the highly customizable and lightweight GraphQL client for React, Vue, Svelte, and vanilla JavaScript. You help developers fetch GraphQL data with minimal bundle size, document caching, normalized caching via Graphcache, exchanges (middleware pipeline), subscriptions, and offline support — providing a leaner alternative to Apollo Client with better extensibility.

Provides PostgreSQL query patterns covering SELECT, JOINs, subqueries, CTEs, window functions, and advanced SQL techniques.

SQL patterns for database querying and design

Analyze SQLite databases using the better-sqlite3 Node.js library, including querying, inserting, and iterating over rows.

Write SOQL queries that group or filter records by date periods using the 13 SOQL date functions, with rules for WHERE vs GROUP BY placement, date-literal comparisons, and fiscal-year restrictions.

Use when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with ORMs like Prisma, Drizzle, TypeORM, or SQLAlchemy.

Connect to PostgreSQL, MySQL, SQLite, and SQL Server databases using SQLAlchemy, Pandas, and DuckDB. Read and write tables, manage sessions, and handle connection strings securely.

Prepare Supabase-compatible persistent storage for a dynamic QW Page. Use with qw-pages when a webpage needs database tables, server-side persistence, Supabase access, or database-backed APIs.

Runs SQL queries and data conversions on CSV, Parquet, and JSON files using the DuckDB command-line interface, including schema inspection and output formatting.

Explains syntax differences for common SQL operations across PostgreSQL, MySQL, SQL Server, and Oracle, including auto-increment keys, string concatenation, date functions, pagination, booleans, JSON, case sensitivity, and recursive CTEs.

KQL language expertise for writing correct, efficient Kusto Query Language queries. Covers syntax gotchas, join patterns, dynamic types, datetime pitfalls, regex patterns, serialization, memory management, result-size discipline, and advanced functions (geo, vector, graph).

Use when implementing SQL functionality with production-grade patterns and safeguards.

Translates natural language data intents into syntactically valid Perfetto SQL queries and executes them against a local trace file using trace_processor.

Provides code samples and best practices for using the Azure Tables SDK for Python to perform NoSQL key-value storage, entity CRUD, batch operations, and queries against Azure Storage Tables or Cosmos DB Table API.

Write correct, efficient Kusto Query Language queries with coverage of syntax, joins, dynamic types, datetime pitfalls, regex, serialization, memory management, and advanced functions.

Build and manage Supabase projects including Database, Auth, Edge Functions, Realtime, Storage, Vectors, Cron, and Queues with security best practices.

Manages and analyzes Azure SQL databases via Azure CLI, covering DTU/vCore performance, elastic pools, geo-replication, and health monitoring.

Configures and troubleshoots Salesforce CPQ pricing: Price Rules, Discount Schedules, Block Pricing, Percent of Total, and Contracted Prices.

SQL with dbt. SQL queries.

Optimizes SQL queries by analyzing execution plans, rewriting patterns, and applying performance techniques for PostgreSQL and MySQL.

Foundational SQL patterns for query writing, schema design, and dialect differences. Use when writing SQL queries, designing database schemas, understanding SQL syntax across PostgreSQL/MySQL/SQLite, or preparing SQL for conversion to other query languages. This is a meta-skill for SQL derivatives.

Enforces SQL quality gates after every implementation: lint with SQLFluff, validate migrations with Flyway or Liquibase, and run database tests with pgTAP or equivalents.

Optimizes SQL queries, designs database schemas, and troubleshoots performance issues using execution plan analysis, indexing strategies, and set-based operations.

Translate natural language into SQL queries, optimize database performance, generate migrations, explore schemas, and work with ORMs across PostgreSQL, MySQL, SQLite, and SQL Server.

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.

Senior human-style UAT and product QA for Vercel-deployed Next.js + Supabase apps. Use when Nick asks to test an app, QA a deploy, check for bugs, run E2E/UAT, smoke test, validate signup/login flows, test a feature, or assess whether a URL is ready for users. Always start by understanding the product and source code before browser testing when code is available.