QuestTree

SQL Online IDE - Fast SQL Editor | SQL Compiler

SQL OnLine - SQLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error helper, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, BI Analytics

概览

收录于

2026年3月17日

学科与领域

computer-science-fundamentals · database-systems

年级范围

九年级（高一）–十二年级（高四）

页面类型

Tool

关键词

sqlite sqlite online data science sqlite viewer sqlite editor sqlite manager sqlite browserselectinsertupdatedeletesql

简介

SQL Online IDE Features and Virtual Table Syntax

  • Remote Database Loading: Supports loading SQLite databases via URL (e.g., Chinook, NorthWind, Sakila).
  • Remote Script Execution: Supports loading and executing external SQL scripts via URL.
  • Virtual Tables: Enables querying external data sources directly using SQL via the CREATE VIRTUAL TABLE syntax.
  • Supported External Formats:
    • JSON: Supports both object arrays and arrays of arrays.
    • CSV: Supports custom skip rows, delimiters, and quoting.
    • Database Sources: Allows querying external databases using specific group names, DB names, and SQL queries.
    • History Sources: Allows querying historical data using UIDs and page numbers.
  • Federated Queries: Designed for performing queries across multiple APIs and datasets.
  • Technical Note: Virtual table functionality is currently limited to the SQLite demo environment.
访问资源

用户评价

暂无已发布的评价，欢迎率先分享您的使用体验。