[IGNITE-15212] [Ignite 3] SQL API design.

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0-alpha5
• Component/s: sql
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Andrey Mashenkov
• Reporter: Andrey Mashenkov
• Created: 30/Jul/21 09:22
• Updated: 26/May/22 10:42
• Resolved: 13/Apr/22 09:07

Description

We need an SQL API for executing queries, query management, and maybe other stuff like statistics management.

Let's consider

1. sync, async and reactive ways for query execution and compare other vendor's API.
2. potential integrations with frameworks like
   • Reactor - rich API for working with reactive streams [1],
   • R2DBC - reactive analog of JDBC [2]
   • JOOQ - query builder. [3]

and then propose a draft of how SQL API could look like for further IEP.

[1] https://projectreactor.io/
[2] https://r2dbc.io/
[3] https://www.jooq.org/

Issue Links

• blocks: IGNITE-14972 Thin 3.0: Implement SQL API for java thin client
• is a child of: IGNITE-15497 [Ignite 3] Native SQL API.
• relates to: IGNITE-17038 Improve SQL API
• links to: GitHub Pull Request #326