Compatible with OpenSearch and OpenSearch Dashboards Version 2.5.0 ### Features ### Refactoring * The SQL Plugin was rearranged into separate repositories ([#640](https://github.com/opensearch-project/sql/issues/640) [#1263](https://github.com/opensearch-project/sql/issues/1263)) * Added SQL-Jdbc repository https://github.com/opensearch-project/sql-jdbc ([#964](https://github.com/opensearch-project/sql/issues/964)) * Added SQL-Jdbc maven artifact as a dependency ([#2692](https://github.com/opensearch-project/opensearch-build/issues/2692)) * Added SQL-Odbc repository https://github.com/opensearch-project/sql-odbc ([#965](https://github.com/opensearch-project/sql/issues/965)) * Added SQL-Cli repository https://github.com/opensearch-project/sql-cli ([#966](https://github.com/opensearch-project/sql/issues/966)) * Added Workbench repository https://github.com/opensearch-project/dashboards-query-workbench ([#1266](https://github.com/opensearch-project/sql/issues/1266)) ### Enhancements * Add low-level create table and table exists API ([#834](https://github.com/opensearch-project/sql/issues/834)) * Add time window and window assigner ([#950](https://github.com/opensearch-project/sql/issues/950)) * Add valueOf() to Expression ([#1055](https://github.com/opensearch-project/sql/issues/1055)) * Add Statement, QueryExecution and QueryManager ([#845](https://github.com/opensearch-project/sql/issues/845)) * Add Streaming Source Impl ([#994](https://github.com/opensearch-project/sql/issues/994)) * Add watermark generator ([#959](https://github.com/opensearch-project/sql/issues/959)) * Add stream context and window trigger ([#958](https://github.com/opensearch-project/sql/issues/958)) * Add micro batch streaming execution ([#1044](https://github.com/opensearch-project/sql/pull/1044)) * Add Streaming Plan Impl ([#1068](https://github.com/opensearch-project/sql/issues/1068)) * Add CBRT to the V2 engine ([#1081](https://github.com/opensearch-project/sql/issues/1081)) * Add CBRT function to the PPL ([#1097](https://github.com/opensearch-project/sql/issues/1097)) * Add timeout option to SQL CLI tool. ([#1076](https://github.com/opensearch-project/sql/issues/1076)) * Add Day_Of_Year Function To OpenSearch ([#1128](https://github.com/opensearch-project/sql/issues/1128)) * Add Week_Of_Year Function To OpenSearch ([#1127](https://github.com/opensearch-project/sql/issues/1127)) * Add Month_Of_Year Function To OpenSearch ([#1129](https://github.com/opensearch-project/sql/issues/1129)) * Add Minute_Of_Day Function To SQL Plugin ([#1207](https://github.com/opensearch-project/sql/issues/1207) [#1214](https://github.com/opensearch-project/sql/issues/1214)) * Add Second_Of_Minute Function As An Alias Of The Second Function ([#1231](https://github.com/opensearch-project/sql/issues/1231) [#1237](https://github.com/opensearch-project/sql/issues/1237)) * Add Support For Legacy Syntax For Match Function In New Engine ([#1090](https://github.com/opensearch-project/sql/issues/1090)) * Add MatchPhraseQuery As Alternate Syntax for Match_Phrase Function ([#1103](https://github.com/opensearch-project/sql/issues/1103)) * Use query execution start time as the value of now-like functions. ([#1047](https://github.com/opensearch-project/sql/issues/1047)) * Add Support for Alternate Legacy MULTIMATCH syntax ([#1102](https://github.com/opensearch-project/sql/issues/1102)) * Add position() function to V2 engine ([#1121](https://github.com/opensearch-project/sql/issues/1121)) * Add position() string function to PPL ([#1147](https://github.com/opensearch-project/sql/issues/1147)) * Add support for wildcard_query function to the new engine ([#156](https://github.com/opensearch-project/sql/issues/156) [#1108](https://github.com/opensearch-project/sql/issues/1108)) * Add reverse() string function to V2 SQL Engine([#1154](https://github.com/opensearch-project/sql/issues/1154)) * Add table write operator and builder ([#1094](https://github.com/opensearch-project/sql/issues/1094)) * Add BETWEEN expression in v2 engine ([#1163](https://github.com/opensearch-project/sql/issues/1163)) * Adding UTC_DATE, UTC_TIME, UTC_TIMESTAMP ([#1193](https://github.com/opensearch-project/sql/issues/1193) [#1198](https://github.com/opensearch-project/sql/issues/1198)) * Validate field and fields parameters in relevance search functions ([#1067](https://github.com/opensearch-project/sql/issues/1067) [#1199](https://github.com/opensearch-project/sql/issues/1199)) * Add `TIMEDIFF` and `DATEDIFF` functions. ([#131](https://github.com/opensearch-project/sql/issues/131) [#1195](https://github.com/opensearch-project/sql/issues/1195) [#1234](https://github.com/opensearch-project/sql/issues/1234)) * Add functions `ADDTIME` and `SUBTIME`. ([#132](https://github.com/opensearch-project/sql/issues/132) [#1194](https://github.com/opensearch-project/sql/issues/1194) [#1252](https://github.com/opensearch-project/sql/issues/1252)) * Add Day_Of_Week Function As An Alias Of DayOfWeek ([#190](https://github.com/opensearch-project/sql/issues/190) [#1228](https://github.com/opensearch-project/sql/issues/1228) [#1239](https://github.com/opensearch-project/sql/issues/1239)) * Add Minute_Of_Hour Function As An Alias Of Minute Function ([#1253](https://github.com/opensearch-project/sql/issues/1253)) * Add support for long value return for CEIL, CEILING and FLOOR math functions ([#1205](https://github.com/opensearch-project/sql/issues/1205)) * Add Alternate Syntax For Match_Query And Other Functions ([#1166](https://github.com/opensearch-project/sql/issues/1166)) * Add Support For `TIME` Type in DAY_OF_YEAR Functions ([#199](https://github.com/opensearch-project/sql/issues/199) [#1223](https://github.com/opensearch-project/sql/issues/1223) [1#258](https://github.com/opensearch-project/sql/issues/1258)) * Add Day_Of_Month Function As An Alias Of DayOfMonth ([#1227](https://github.com/opensearch-project/sql/issues/1227) [#1265](https://github.com/opensearch-project/sql/issues/1265)) * Add security patch for CVE-2020-15250 ([#1095](https://github.com/opensearch-project/sql/issues/1095)) * Add security patch for CVE-2022-45868 ([#1107](https://github.com/opensearch-project/sql/issues/1107)) * Add Hour_Of_Day Function As An Alias Of Hour ([#1226](https://github.com/opensearch-project/sql/issues/1226) [#1270](https://github.com/opensearch-project/sql/issues/1270)) ### Bug Fixes * Fix `FLOAT` -> `DOUBLE` cast. ([#1025](https://github.com/opensearch-project/sql/issues/1025)) * Fix error messaging from prometheus. ([#1029](https://github.com/opensearch-project/sql/issues/1029) [#1037](https://github.com/opensearch-project/sql/issues/1037)) * Add `query` function as alternate syntax to `query_string` function ([#1010](https://github.com/opensearch-project/sql/issues/1010)) * Deprecate span collector ([#990](https://github.com/opensearch-project/sql/issues/990)) * back quote fix ([#1041](https://github.com/opensearch-project/sql/issues/1041) [#1050](https://github.com/opensearch-project/sql/issues/1050)) * Update DATE and TIME functions to parse string input as datetime ([#991](https://github.com/opensearch-project/sql/issues/991)) * Integ tests fix for arm64 ([#1069](https://github.com/opensearch-project/sql/issues/1069)) * Fix history file usage in SQL CLI tool. ([#1077](https://github.com/opensearch-project/sql/issues/1077)) * Update Jackson to 2.14.1 and fix dependency resolution issues ([#1150](https://github.com/opensearch-project/sql/issues/1150)) * Change LIKE operator case-insensitive match ([#1160](https://github.com/opensearch-project/sql/issues/1160)) * Fix arithmetic operator precedence ([#1172](https://github.com/opensearch-project/sql/issues/1172) [#1188](https://github.com/opensearch-project/sql/issues/1188)) * Fix back quoted alias of FROM subquery ([#1189](https://github.com/opensearch-project/sql/issues/1189) [#1208](https://github.com/opensearch-project/sql/issues/1208)) * Fix truncate function ([#1197](https://github.com/opensearch-project/sql/issues/1197) [#1213](https://github.com/opensearch-project/sql/issues/1213)) * Allow common keywords and scalar function name used as identifier ([#1191](https://github.com/opensearch-project/sql/issues/1191) [#1212](https://github.com/opensearch-project/sql/issues/1212)) * Suppress report uploading failure in CI. ([#1180](https://github.com/opensearch-project/sql/issues/1180) [#1220](https://github.com/opensearch-project/sql/issues/1220)) * Fixed error with single timestamp query ([#1244](https://github.com/opensearch-project/sql/issues/1244) [#1246](https://github.com/opensearch-project/sql/issues/1246) [#1249](https://github.com/opensearch-project/sql/issues/1249)) * Support JOIN query on object field with unexpanded name ([#1229](https://github.com/opensearch-project/sql/issues/1229) [#1250](https://github.com/opensearch-project/sql/issues/1250)) * Bug fix for less than and greater than operators on @timestamp ([#1267](https://github.com/opensearch-project/sql/issues/1267) [#1272](https://github.com/opensearch-project/sql/issues/1267)) ### Infrastructure * Change ApplicationContext lifecycle to per node level ([#822](https://github.com/opensearch-project/sql/issues/822)) * Catalog to Datasource changes ([#1027](https://github.com/opensearch-project/sql/issues/1027) [#1049](https://github.com/opensearch-project/sql/issues/1049) [#1086](https://github.com/opensearch-project/sql/issues/1086)) * Bump jackson to 2.14.0 ([#1058](https://github.com/opensearch-project/sql/issues/1058)) * Add metadatalog interface and default in memory implementation ([#974](https://github.com/opensearch-project/sql/issues/974)) * Decouple function repository and DSL from IoC container for use anywhere ([#1085](https://github.com/opensearch-project/sql/issues/1085)) * Move DataSourceServiceImpl to core module ([#1084](https://github.com/opensearch-project/sql/issues/1084)) * Improve pushdown optimization and logical to physical transformation ([#1091](https://github.com/opensearch-project/sql/issues/1091)) * Using jackson and jackson_databind version defined in OpenSearch ([#1169](https://github.com/opensearch-project/sql/issues/1169) [#1173](https://github.com/opensearch-project/sql/issues/1173)) * Add BWC tests for running against distribution bundle. ([#1209](https://github.com/opensearch-project/sql/issues/1209)) ### Documentation * Support opensearch-sql:run and update developer_guide doc ([#1099](https://github.com/opensearch-project/sql/issues/1099)) * Updated MAINTAINERS.md to match recommended opensearch-project format. ([#1224](https://github.com/opensearch-project/sql/issues/1224) [#1233](https://github.com/opensearch-project/sql/issues/1233))