Re: [PR] docs: propose Layer 3 execute_query MCP profile [ossie]

["christianeu-db (via GitHub)" <gi...@apache.org>]

christianeu-db commented on code in PR #529:
URL: https://github.com/apache/ossie/pull/529#discussion_r4333751337


##########
validation/mcp/execute-query-query.schema.json:
##########
@@ -0,0 +1,146 @@
+{
+  "$comment": "Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See NOTICE for copyright ownership. Licensed under the Apache License, Version 2.0; http://www.apache.org/licenses/LICENSE-2.0 . Unless required by applicable law or agreed to in writing, distributed on an AS IS BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND. Generated by scripts/generate-mcp-profile.py; do not edit.",
+  "$id": "urn:apache:ossie:execute-query:query:0.4-draft",
+  "$schema": "https://json-schema.org/draft/2020-12/schema",
+  "$ref": "#/$defs/query",
+  "$defs": {
+    "expression": {
+      "type": "string",
+      "minLength": 1,
+      "pattern": "\\S"
+    },
+    "projection": {
+      "type": "array",
+      "items": {
+        "$ref": "#/$defs/expression"
+      }
+    },
+    "predicate": {
+      "oneOf": [
+        {
+          "$ref": "#/$defs/expression"
+        },
+        {
+          "type": "array",
+          "minItems": 1,
+          "items": {
+            "$ref": "#/$defs/expression"
+          }
+        }
+      ]
+    },
+    "query": {

Review Comment:
   I'm wondering whether we could also support Layer 2 SQL.
   
   This would use Ossie SQL's declarative extensions for querying measures on datasets via AGG(). Like Layer 3, these queries would ultimately be compiled to native SQL. For example, joins involving AGG() would likely be rewritten as correlated subqueries.
   
   The reason I ask is that Layer 2 is now merged / we'll hopefully have some compliance tests for it soon.
   
   Layer 3 still remains a draft (but hopefully, the community can align on an MVP to merge)



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@ossie.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org