sqlgen

mirror/sqlgen

Fork 0

mirror of https://github.com/getml/sqlgen.git synced 2026-05-05 22:53:46 -05:00

Commit Graph

Select branches

Hide Pull Requests

f/improved_documentation

f/set_optional{

main

#1

#10

#101

#102

#103

#105

#106

#11

#110

#111

#112

#113

#114

#115

#117

#12

#120

#121

#122

#123

#123

#125

#126

#126

#13

#14

#15

#16

#17

#19

#2

#20

#21

#23

#24

#25

#26

#27

#28

#29

#3

#30

#32

#33

#34

#35

#36

#37

#38

#39

#4

#40

#42

#43

#44

#45

#48

#49

#5

#51

#54

#56

#57

#58

#6

#60

#61

#65

#66

#67

#7

#71

#72

#73

#75

#76

#8

#81

#82

#83

#84

#85

#86

#89

#9

#90

#91

#92

#93

#94

#95

#96

#97

#98

v0.1.0

v0.2.0

v0.3.0

v0.4.0

v0.5.0

v0.6.0

7e5e6d11bf #124 Adding support for invalidating cache objects (#125) main Scott Fries 2026-03-10 11:02:00 -06:00
5768fb9aa2 Add parameterized execute for postgres (#122) Marco Craveiro 2026-02-08 00:57:01 +00:00
a414397705 Use environment variables for postgres and MySQL test credentials (#121) Marco Craveiro 2026-02-07 00:36:57 +00:00
2b877f24d8 Add PostgreSQL notice processor support (#120) Marco Craveiro 2026-02-03 09:28:27 +00:00
a866fe476d Added proper documentation for sqlgen::insert_or_replace; resolves #116 (#117) Dr. Patrick Urbanke (劉自成) 2026-01-24 17:20:14 +01:00
0db1670c01 Documented support for multiple primary keys; resolves #107 (#115) Dr. Patrick Urbanke (劉自成) 2026-01-01 12:51:58 +01:00
587cff4201 Bump sqlgen version to 0.6.0 (#114) v0.6.0 Dr. Patrick Urbanke (劉自成) 2026-01-01 12:38:24 +01:00
a558c7bb23 Use unique cursor names in postgres (#113) Dr. Patrick Urbanke (劉自成) 2025-12-31 00:56:19 +01:00
9d0f0a29ab Use monadic error handling in postgres (#112) Dr. Patrick Urbanke (劉自成) 2025-12-31 00:56:04 +01:00
c8f4ad8d84 Better support for nullable values in UPDATE...SET, resolves #108 (#111) Dr. Patrick Urbanke (劉自成) 2025-12-26 12:51:23 +01:00
a181fe8ab8 Added more tests f/set_optional{ Dr. Patrick Urbanke 2025-12-26 10:59:22 +01:00
943247cec3 Made sure that setting to NULL values works Dr. Patrick Urbanke 2025-12-26 10:55:30 +01:00
3600ae8199 Made sure the .set(...) works for nullable values Dr. Patrick Urbanke 2025-12-25 16:04:21 +01:00
0ea4d461d4 Implement listen / notify support for Postgres (#104) (#105) Marco Craveiro 2025-12-17 23:12:07 +00:00
ba39bb2730 Replace enable_if with concepts (#106) Dr. Patrick Urbanke (劉自成) 2025-12-08 00:13:11 +01:00
758bb1d87e Expand the is_connection concept to iterators (#103) Dr. Patrick Urbanke (劉自成) 2025-12-06 23:20:11 +01:00
657a9fd4ee Implement offset support (#102) Marco Craveiro 2025-12-03 21:55:59 +00:00
cd42a4e4cf Make sure that iterators work with sessions; fixes #99 (#101) Dr. Patrick Urbanke (劉自成) 2025-11-29 19:33:09 +01:00
c8bc840530 Better documentation for sqlgen::unite f/improved_documentation Dr. Patrick Urbanke 2025-11-25 21:52:43 +01:00
8b658d6137 Bump sqlgen version to 0.5.0 (#98) v0.5.0 Dr. Patrick Urbanke (劉自成) 2025-11-25 20:09:04 +01:00
e85f262f6d Minor code beautifications for DuckDB (#94) Dr. Patrick Urbanke (劉自成) 2025-11-25 20:08:05 +01:00
b2e4cba591 Fix select_from usage in unite.md example (#97) Dr. Patrick Urbanke (劉自成) 2025-11-23 23:57:15 +01:00
287ac58bf6 Added support for UNION and UNION ALL (#96) Dr. Patrick Urbanke (劉自成) 2025-11-23 23:55:42 +01:00
7e4fa42bd9 Use RAII principles for postgres (#93) Dr. Patrick Urbanke (劉自成) 2025-11-21 20:38:56 +01:00
8568a83362 Added support for DuckDB (#90) Dr. Patrick Urbanke (劉自成) 2025-11-20 21:20:12 +01:00
e07be25a5d Fix memory management for postgres in edge cases (#89) Marco Craveiro 2025-11-14 11:34:22 +00:00
5131953c35 Generate .lib files when building shared on Windows; Bumped to version 0.4.0 (#86) v0.4.0 Dr. Patrick Urbanke (劉自成) 2025-11-03 01:02:00 +01:00
86884f388a Use reflect-cpp 0.22.0 (#85) Dr. Patrick Urbanke (劉自成) 2025-11-02 00:46:55 +01:00
c4305f6a17 Added checks to make sure that the headers are self-contained (#84) Dr. Patrick Urbanke (劉自成) 2025-11-01 19:47:19 +01:00
86ee6e2bcc Added a caching strategy (#83) Dr. Patrick Urbanke (劉自成) 2025-11-01 14:30:58 +01:00
4cc3e871c3 Explicitly set alias; fixes #80 (#82) Dr. Patrick Urbanke (劉自成) 2025-10-30 21:49:03 +01:00
e4cf6c802b Use sqlite_prepare_v3; resolved #77; fixes #78 (#81) Dr. Patrick Urbanke (劉自成) 2025-10-27 23:17:23 +01:00
e6b468af9b Added tests for schemata (#76) Dr. Patrick Urbanke (劉自成) 2025-10-24 08:14:34 +02:00
91e993ffdd Make sure we can use boolean values in conditions; fixes #74 (#75) Dr. Patrick Urbanke (劉自成) 2025-10-23 23:30:58 +02:00
15108fba46 Handle schemas in SQL generation; resolves #70 (#71) Marco Craveiro 2025-10-23 18:30:40 +01:00
816ca6adec Fixed issue with boolean data; resolves #69 (#72) Dr. Patrick Urbanke (劉自成) 2025-10-22 23:15:47 +02:00
6c0af08321 Made sure that you can still insert after a failure; resolves #68 (#73) Dr. Patrick Urbanke (劉自成) 2025-10-22 22:06:09 +02:00
3076ea2c8c Make sure that special value types can be added to conditions; resolves #63 (#67) Dr. Patrick Urbanke (劉自成) 2025-10-19 21:38:09 +02:00
1bfc4e472b Make sure that adding tags to columns only compiles when the corresponding tables exist in the query; resolves #59 Dr. Patrick Urbanke (劉自成) 2025-10-19 18:48:17 +02:00
3736fcc29c Better implementation for value_t; fixes #64 (#65) Dr. Patrick Urbanke (劉自成) 2025-10-14 23:11:08 +02:00
9c67ff24e4 Refactored the write and read function (#61) Dr. Patrick Urbanke (劉自成) 2025-10-10 01:22:15 +02:00
3769f50501 Refactor iterators to make sure we can use them for DuckDB (#60) Dr. Patrick Urbanke (劉自成) 2025-10-07 23:51:15 +02:00
4e98b9c0aa Removed CMakeUserPresets.json; Bumped version to 0.3.0 (#58) v0.3.0 Dr. Patrick Urbanke (劉自成) 2025-10-05 10:52:15 +03:00
4713e88fe7 Fix documentation related to views and SQLite (#57) Dr. Patrick Urbanke (劉自成) 2025-10-03 23:15:53 +03:00
ce302f54de Made sure that nullability rules are applied properly when joining tables (#56) Dr. Patrick Urbanke (劉自成) 2025-10-03 22:54:46 +03:00
45c1a52177 Added support for IN and NOT IN; resolves #53 (#54) Dr. Patrick Urbanke (劉自成) 2025-09-28 22:28:48 +03:00
8649e41861 Fixed typo in select_from (#51) Dr. Patrick Urbanke (劉自成) 2025-09-21 12:00:48 +03:00
7a617b0828 Add enum support (#49) hosein 2025-09-21 09:00:15 +02:00
26869c83f1 Added support for JSON fields (#48) Dr. Patrick Urbanke (劉自成) 2025-09-13 08:29:26 +02:00
8b6b6c5a59 Implement insert_or_replace (#45) Demian Nave 2025-09-07 05:14:02 -04:00
82e1c193d3 Minor improvements to dynamic types (#44) Dr. Patrick Urbanke (劉自成) 2025-08-21 22:32:11 +02:00
5c8cf00625 Add a generic Dynamic type for db-specific columns (#43) hosein 2025-08-21 20:08:32 +02:00
b46c3fe03d Added support for CREATE TABLE AS and CREATE VIEW AS (thus adding support for views) (#40) Dr. Patrick Urbanke (劉自成) 2025-08-10 14:37:22 +02:00
f536efbde9 Added the ability to add subqueries in select_from (#39) Dr. Patrick Urbanke (劉自成) 2025-08-09 00:36:53 +02:00
ad1cae049b Added support for unique columns (#38) Dr. Patrick Urbanke (劉自成) 2025-08-03 22:12:31 +02:00
098deb9477 Added support for foreign key constraints (#37) Dr. Patrick Urbanke (劉自成) 2025-08-02 12:48:17 +02:00
7d9cd0d38f Fixed typo in README.md (#36) Dr. Patrick Urbanke (劉自成) 2025-08-01 16:47:16 +02:00
52dd2b1ea8 Added comment in the README.md (#35) Dr. Patrick Urbanke (劉自成) 2025-08-01 00:11:48 +02:00
dd5b73b772 Added the insert example to the README (#34) Dr. Patrick Urbanke (劉自成) 2025-07-30 21:40:20 +02:00
3f8c5556d2 Added support for MySQL (#33); resolves #18 v0.2.0 Dr. Patrick Urbanke (劉自成) 2025-07-27 12:25:12 +02:00
1424d29c5d Put the literals into a separate namespace; resolves #31 (#32) Dr. Patrick Urbanke (劉自成) 2025-07-23 22:32:26 +02:00
7b5c849e02 Set transitive_headers=True (#30) Dr. Patrick Urbanke (劉自成) 2025-07-20 17:37:41 +02:00
0ad99d983a Added support for Conan (#29) v0.1.0 Dr. Patrick Urbanke (劉自成) 2025-07-18 22:31:19 +02:00
db1b434320 Added more rigorous checks to the select_from query (#28) Dr. Patrick Urbanke (劉自成) 2025-07-16 23:35:18 +02:00
e443cb56e0 Make sure we properly check the columns in the ORDER BY clause when there is a GROUP BY (#27) Dr. Patrick Urbanke (劉自成) 2025-07-15 22:43:00 +02:00
1170f22d69 Added examples for joins to the README (#26) Dr. Patrick Urbanke (劉自成) 2025-07-15 20:17:37 +02:00
b283ccf388 Added support for joins (#25) Dr. Patrick Urbanke (劉自成) 2025-07-15 08:55:34 +02:00
f95156df77 Added operations on time stamps (#24) Dr. Patrick Urbanke (劉自成) 2025-07-02 20:04:50 +02:00
aa1a96f1c0 Add auto-incrementing primary keys (#23) Dr. Patrick Urbanke (劉自成) 2025-06-24 22:34:50 +02:00
e4b821138a Prohibit nested aggregations (#21) Dr. Patrick Urbanke (劉自成) 2025-06-23 22:55:46 +02:00
30ba548f1e Added numerous operations like concat(...), coalesce(...), abs(...), etc (#20) Dr. Patrick Urbanke (劉自成) 2025-06-22 18:05:48 +02:00
a6bad187fe Refactor: Main functions as hidden friends (#19) Dr. Patrick Urbanke (劉自成) 2025-06-14 10:32:52 +02:00
775f15babf Added aggregations and GROUP BY (#17) Dr. Patrick Urbanke (劉自成) 2025-06-08 12:30:59 +02:00
21564cacf6 Update README.md to include reference to reflect-cpp (#16) Dr. Patrick Urbanke (劉自成) 2025-05-31 23:21:39 +02:00
50800fdf0c Added type checks (#15) Dr. Patrick Urbanke (劉自成) 2025-05-29 19:45:01 +02:00
3d8c4ecbf1 Added .is_null(), .is_not_null(), .like(), .not_like() (#14) Dr. Patrick Urbanke (劉自成) 2025-05-26 21:45:00 +02:00
97cce29ae6 Build test pipelines on every push (#13) Dr. Patrick Urbanke (劉自成) 2025-05-25 23:01:34 +02:00
38e9b6de82 Update connection_pool.md (#12) Dr. Patrick Urbanke (劉自成) 2025-05-25 10:53:02 +02:00
80f5e84a42 Added a connection pool (#11) Dr. Patrick Urbanke (劉自成) 2025-05-25 10:42:40 +02:00
622c44efbb Better transaction management (#10) Dr. Patrick Urbanke (劉自成) 2025-05-24 12:21:50 +02:00
87b911bba2 Use batching for inserts as well (#9) Dr. Patrick Urbanke (劉自成) 2025-05-22 22:48:47 +02:00
04b6a35492 Added the ability to execute raw SQL (#8) Dr. Patrick Urbanke (劉自成) 2025-05-22 22:00:47 +02:00
684bc1e273 Added a GitHub Actions pipeline for macOS (#7) Dr. Patrick Urbanke (劉自成) 2025-05-22 21:33:11 +02:00
c51f1c9c33 Updated README for Windows instructions (#6) Dr. Patrick Urbanke (劉自成) 2025-05-22 08:46:53 +02:00
ea7a1fe8e0 Added a Github Actions pipeline for Windows (#5) Dr. Patrick Urbanke (劉自成) 2025-05-22 08:44:59 +02:00
c88d70dd85 Fixed typo in insert.md (#4) Dr. Patrick Urbanke (劉自成) 2025-05-21 22:30:03 +02:00
3318c40c04 Added a separate insert statement (#3) Dr. Patrick Urbanke (劉自成) 2025-05-21 22:28:02 +02:00
7396ae39b0 Run tests after merge (#2) Dr. Patrick Urbanke (劉自成) 2025-05-20 22:05:32 +02:00
d2da86800b Added Github Action pipelines for automated testing Dr. Patrick Urbanke (劉自成) 2025-05-20 21:30:49 +02:00
fa5d0797b2 Specify prs Dr. Patrick Urbanke 2025-05-20 21:24:23 +02:00
e0ce391671 Next attempt Dr. Patrick Urbanke 2025-05-20 21:21:45 +02:00
c75df4f80b Trigger on PR in push in main branch Dr. Patrick Urbanke 2025-05-20 21:18:01 +02:00
290d9cf1b8 Fixed test Dr. Patrick Urbanke 2025-05-20 21:11:23 +02:00
55f3e1f881 Fix password Dr. Patrick Urbanke 2025-05-20 21:05:02 +02:00
d9d99b3bd3 Tried local postgres Dr. Patrick Urbanke 2025-05-20 20:50:18 +02:00
03c3109431 Revert "Next attempt" Dr. Patrick Urbanke 2025-05-20 20:43:20 +02:00
2adc7d0e7a Next attempt Dr. Patrick Urbanke 2025-05-20 20:42:29 +02:00
8aa2aabec3 Integrated postgres into our own build pipeline Dr. Patrick Urbanke 2025-05-20 20:38:11 +02:00
740930ef14 Added a postgres container Dr. Patrick Urbanke 2025-05-20 20:33:26 +02:00
bf8a20b51d Removed flag not supported by Clang Dr. Patrick Urbanke 2025-05-20 08:59:00 +02:00

1 2 3 4 5 ...