Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Common Table Expressions #1124

Merged
merged 208 commits into from
Apr 4, 2024
Merged

Common Table Expressions #1124

merged 208 commits into from
Apr 4, 2024

Conversation

trueqbit
Copy link
Collaborator

@trueqbit trueqbit commented Jan 22, 2023 •
edited

@trueqbit
A first implementation of common table expressions
dde241e
@trueqbit
Prepared for multiple CTEs
f8abfdb
@trueqbit
Multiple CTEs
454a821
@trueqbit
Included util.h in storage.h
0a9624c
@trueqbit
ad hoc storage implementation for expression
5c3d3aa
@trueqbit
Improve readability
0ef34ff
@trueqbit
Curated storage implementation interface
31e204f
@trueqbit
Explicit column names for CTE
3546af3
@trueqbit
Cleanup code while programming CTEs
8fb53cd
@trueqbit
Allow compound statements for recursive CTEs
21f976a
@trueqbit
Complex recursive CTEs
df34bb5
@trueqbit
Ability to order by nth column
3b8473f
@trueqbit
Provided dump function for expressions
805b2c9
@trueqbit
Added cte.h to amalgamation script
908dab4
@trueqbit
Added a few with-clause examples
e4092bf
@trueqbit
Ability to select all columns from aliased table
85d92e1
@trueqbit
Removed 'get table' accessor from storage implementation
eb7971e
@trueqbit
Validate number of columns of CTE
518677e
@trueqbit
Implemented simple multi-argument min/max core functions
09703ec
@trueqbit
Most CTE examples are available only with std::optional
5beffa1
@trueqbit
"Apfelmaennchen" (Mandelbrot set) example
024f427
@trueqbit
#include <optional> in CTE examples file
c5aa19f
@trueqbit
Abstracted table object mapping
d8fd046
@trueqbit
Renamed label_type typename alias to cte_label_type
c6b461f 
This change mitigates the problem that `label_type` might be a present outside of sqlite_orm's type system
@trueqbit
Renamed common_table_expression::expression -> subselect
ff086f6
@trueqbit
Ability to build storage columns by integral member pointer constant
532c430 
This changeset makes `asterisk<Object>` for work CTEs
@trueqbit
Implemented getting column expression from aliased asterisk expression
749ce47
@trueqbit
Static unit tests for column expression types
c772d09
@trueqbit
Added explicit as() call CTE builder
7582330
@trueqbit
Provided polyfill::remove_cvref for C++17
1ec9350
@trueqbit
Merge remote-tracking branch 'upstream/dev' into CTEs
b7213ab
@trueqbit
Corrected unit tests for table name collector
f6e1c97
@trueqbit
Uniform syntax for column pointer expressions through table references
6b0613d
@trueqbit
Merge remote-tracking branch 'upstream/dev' into CTEs
57b5097
@trueqbit
Further unit tests for CTE expressions
348a803
@trueqbit
Table reference can be specified in call to make_table()
3a9665b
@trueqbit
Merge remote-tracking branch 'upstream/dev' into CTEs
4d68adf
@trueqbit
CTE with raw insert statements
3c914e5
@trueqbit
Merge remote-tracking branch 'origin/fixes/operators_adl' into CTEs
6b406c5
@trueqbit
Moved CTE string literal operators into inline namespace
fe696b6
@trueqbit
Merge remote-tracking branch 'origin/fixes/operators_adl' into CTEs
31c6d30
@trueqbit
Merge remote-tracking branch 'upstream/dev' into CTEs
508d0d7
@trueqbit
Rephrased comment
b2c77f2
@trueqbit
Merge remote-tracking branch 'origin/simplified_expression_object_typ…
5ef6d4e 
…e' into CTEs
@trueqbit
Streamlined tuple traits and algorithms
fcf85d6 
* Metafunctions for finding, counting and checking type lists (tuples)
@trueqbit
Merge branch 'streamlined_tuple_algos' into CTEs
8e67751
@trueqbit
Merge remote-tracking branch 'upstream/dev' into CTEs
60eb1a8
fnc12
fnc12 requested changes Jan 23, 2024
View reviewed changes
dev/alias.h Outdated Show resolved Hide resolved
dev/column_pointer.h Show resolved Hide resolved
dev/column_pointer.h Show resolved Hide resolved
dev/column_pointer.h Show resolved Hide resolved
dev/cte_types.h Show resolved Hide resolved
examples/common_table_expressions.cpp Outdated Show resolved Hide resolved
tests/ast_iterator_tests.cpp Outdated Show resolved Hide resolved
tests/statement_serializer_tests/aggregate_functions.cpp Show resolved Hide resolved
tests/statement_serializer_tests/select_constraints.cpp Outdated Show resolved Hide resolved
tests/tests3.cpp Show resolved Hide resolved
@fnc12 fnc12 self-requested a review April 4, 2024 14:53
@fnc12
Copy link
Owner

fnc12 commented Apr 4, 2024

code LGBT

@trueqbit trueqbit merged commit 4ba4cea into fnc12:dev Apr 4, 2024
2 checks passed
@trueqbit
Copy link
Collaborator Author

trueqbit commented Apr 4, 2024

Common Table Expressions are here! It's been a long journey that spawned many other improvements and fixes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@fnc12 fnc12 fnc12 approved these changes

Assignees
No one assigned
Labels
feature
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

Select in other select is sqlite_orm now supported with recursive The WITH clause
2 participants
@trueqbit @fnc12