v3.0.0-beta.11

What's Changed

• fix(views): transformation using raw sql by @scaliseraoul in #1608
• fix(dataset): slug format validation on load by @ArslanSaleem in #1609
• fix(Views): multiple joins by @scaliseraoul in #1611
• fix(View): fixing aliases in view by @scaliseraoul in #1614

Full Changelog: v3.0.0-beta.10...v3.0.0-beta.11

v3.0.0-beta.10

What's Changed

• fix(Views): updated views to reflect refactors by @scaliseraoul in #1582
• fix(config): dataframe remove config variable class attribute and chat by @ArslanSaleem in #1587
• chore: remove numpy dependency by @christophfroeschl in #1580
• fix(deps): remove numpy strict installation from all extensions by @ArslanSaleem in #1591
• fix(load): update error message in case of dataset not found locally and missing api keys by @ArslanSaleem in #1589
• feature(Views): adding view for local sources by @scaliseraoul in #1586
• feat(sandbox): add sandbox support in pai.chat and df.chat by @ArslanSaleem in #1595
• feature(Views): views for a single dataframe by @scaliseraoul in #1594
• fix: transpiling sql to specific dialect by @scaliseraoul in #1596
• fix(schema): make columns mandatory for view by @scaliseraoul in #1599
• fix(sql_generation): handle scenario where table columns have "from" keyword in query by @ArslanSaleem in #1600
• feature(GroupBy): adding group by functionality by @scaliseraoul in #1603

New Contributors

• @christophfroeschl made their first contribution in #1580

Full Changelog: v3.0.0-beta.8...v3.0.0-beta.10

v3.0.0-beta.9

What's Changed

• fix(Views): updated views to reflect refactors by @scaliseraoul in #1582
• fix(config): dataframe remove config variable class attribute and chat by @ArslanSaleem in #1587
• chore: remove numpy dependency by @christophfroeschl in #1580
• fix(deps): remove numpy strict installation from all extensions by @ArslanSaleem in #1591
• fix(load): update error message in case of dataset not found locally and missing api keys by @ArslanSaleem in #1589
• feature(Views): adding view for local sources by @scaliseraoul in #1586
• feat(sandbox): add sandbox support in pai.chat and df.chat by @ArslanSaleem in #1595
• feature(Views): views for a single dataframe by @scaliseraoul in #1594
• fix: transpiling sql to specific dialect by @scaliseraoul in #1596

New Contributors

• @christophfroeschl made their first contribution in #1580

Full Changelog: v3.0.0-beta.8...v3.0.0-beta.9

v3.0.0-beta.8

What's Changed

• fix(FileManager): updated path in create and pull methods by @scaliseraoul in #1579

Full Changelog: v3.0.0-beta.7...v3.0.0-beta.8

v3.0.0-beta.7

What's Changed

• fix: adding http client parameter in azure_openai.py by @prasum in #1567
• fix(pandasai-sql): dropping support for sqlite by @scaliseraoul in #1558
• feature(SqlLoader): transformations in SqlLoader by @scaliseraoul in #1569
• fix(sql_query): validate if the query is not malicious by @ArslanSaleem in #1568
• test: add more tests in the agent by @gventuri in #1572
• feature(FileManager): adding FileManager to make feasible work with the library in other environment by @scaliseraoul in #1573
• fix(sql): allow paramerized query through sql sanitization by @ArslanSaleem in #1576
• docs: update docs for sql, create, links, examples by @gdcsinaptik in #1571

New Contributors

• @prasum made their first contribution in #1567

Full Changelog: v3.0.0-beta.6...v3.0.0-beta.7

v3.0.0-beta.6

What's Changed

• feat: filter only the columns that are provided in the schema by @gventuri in #1562
• fix(sql): dependencies of sql fixed by @ArslanSaleem in #1564

Full Changelog: v3.0.0-beta.5...v3.0.0-beta.6

v3.0.0-beta.5

What's Changed

• fix(dependencies): update poetry file and pyproject files by @ArslanSaleem in #1557
• feat: add transformations by @gventuri in #1555
• feat: add CLI by @gventuri in #1560

Full Changelog: v3.0.0-beta.4...v3.0.0-beta.5

v3.0.0-beta.4

What's Changed

• feat(sandbox): adding docker sandbox by @ArslanSaleem in #1517

Full Changelog: v3.0.0-beta.3...v3.0.0-beta.4

v3.0.0-beta.3

What's Changed

• docs: updated installation instructions and fixed semantic-layer parsing error by @gdcsinaptik in #1550
• feature(View): extend pai.create to support views by @scaliseraoul in #1549
• fix: removed deprecated df._data by @scaliseraoul in #1552
• feat(sql_connector): add json serialization to text by @ArslanSaleem in #1551
• fix(sql): add params args to pass to the connector by @ArslanSaleem in #1553

Full Changelog: v3.0.0-beta.2...v3.0.0-beta.3

v3.0.0-beta.2

What's Changed

• feat(sql_connector): add support for sql connector by @ArslanSaleem in #1543

Full Changelog: v3.0.0-beta.1...v3.0.0-beta.2