opteryx
opteryx copied to clipboard
mabel-dev
🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives.
/// Dollar quoted string: i.e: $$string$$ or $tag_name$string$tag_name$ DollarQuotedString(DollarQuotedString)
/// `#>`, extracts JSON sub-object at the specified path HashArrow /// `#>>`, extracts JSON sub-object at the specified path as text HashLongArrow /// jsonb @> jsonb -> boolean: Test whether...
~~~sql SELECT satellite_name FROM mission_reports ~~~ ~~~ AFTER OPTIMIZATION └─ EXIT └─ PROJECT [satellite_name] └─ PROJECT [satellite_name] └─ NESTED_INNER JOIN ($view-ba42.id = $view-a06f.planetId) ├─ READ ($satellites AS $view-a06f) [planetId, name]...
Like we rewrite `a LIKE '%s%'` to `a InStr 's'` rewrite so that starts and ends are special internal operators (ones that users can't use) StartsWith IStartsWith NotStartsWith INotStartsWith EndsWith...
for iceberg backed datasets, support table creation and schema validation For iceberg backed tables, support insert and truncate
~~~sql SELECT name FROM $planets UNION SELECT name FROM $planets UNION SELECT name FROM $planets ~~~ > ", line 305, in inner_query_planner > if ast_branch["Select"].get("top") is not None: > ~~~~~~~~~~^^^^^^^^^^...
Probably won't be triggered often, but this is could be rewritten as a MAX/MIN aggregation
~~~sql SELECT name FROM $planets WHERE (name LIKE '%u%' OR name LIKE '%a%') AND (mass > 1e-24 OR diameter < 30000) ~~~ may be other filters, but noticed this testing...
won't always be available, but if we're reading arrow/iceberg struct columns, get the types of each of the attributes
### Thank you for helping maintain the quality and performance of Opteryx. _We appreciate your efforts — your contribution ensures that Opteryx remains reliable and efficient for everyone._ --- **Is...