Phillip Cloud
Phillip Cloud
This PR promotes `ibis.util.psql` to a public `ibis.psql` API. It also fixes the fact that we are writing out the generic sqlglot dialect instead of writing the output in the...
This PR adds support for a SQL `VALUES`-like construct, called `Rows` in ibis. The API entry point is `ibis.rows` which returns a `Table` expression. The motivation is to allow use...
After https://github.com/ibis-project/ibis/pull/4330 we have an implementation of add, multiply, and sub, but we're missing division. As part of fixing this issue, I think it'll make the implementation a lot less...
This PR fixes support for timestamps that are too big for nanosecond resolution. To do this, I had to call `fetch_arrow_table` (before calling `to_pandas` on _that_) because arrow handles coarser...
This PR unifies the result value of `now` between pandas and dask and the SQL backends to be a localized UTC value
`create_table` should support insertion from rows, including list of non-mapping sequences, mappings, and generally anything that behaves like those without modification. Something similar to this: ``` def create_table(tablename, rows=None, schema=None,...
There are a number of places where the terminology of objects with respect to the tree structure in Ibis's internal API isn't correct, particularly around parent/child and root/non-root objects. 1....
I'd like to propose a new and more compact API for window frame specification that is heavily inspired by the SQLAlchemy way of spelling these: ```python t = ibis.table(...) #...
> I'm not in favor of the side effect, but with a follow-up ticket to refactor it to CTEs it LGTM. _Originally posted by @kszucs in https://github.com/ibis-project/ibis/pull/3642#pullrequestreview-930451607_ Indeed, the `.sql`...
Many logically distinct operations like filter, project, and aggregate are fused together into a single operation. While this was useful initially for generating clean SQL, it has a number of...