snthpy

42 ms·

691.
by snthpy 4y ago
Sorry I'm on my phone right now so can't test this out so what does this do exactly? I just have my formula bar set at 3 lines and F2 edits in the formula box always. I find that works well for me. What frustrations do you have wi
692.
by snthpy 4y ago
PRQL actually goes through two intermediary ASTs (PL and RQ) before being compiled into SQL. This is not that well documented yet but you can have a look at the comments at the top of the lib.rs [0]. Both representations are accessible as j
693.
by snthpy 4y ago
This looks very interesting. Have you looked at Substrait.io [1] at all?. The aim of Substrait is similar to what you describe, i.e. to create a universal relational algebra representation that can be executed directly by backend systems wi
694.
by snthpy 4y ago
PRQL actually goes through two intermediary ASTs (PL and RQ) before being compiled into SQL. This is not that well documented yet but have a look at the comments at the top of the lib.rs [0]. Both representations are accessible as json in t
695.
by snthpy 4y ago
Square brackets are for lists/list arguments. Parentheses are when a pipeline/transforms need to be supplied, most notably with `group`. More details here: https://prql-lang.org/book/queries/syntax.html
696.
by snthpy 4y ago
The last example in this notebook [0] shows how similar PRQL is to dplyr. The rest of the notebook shows how you can use PRQL from R, Python and the command line. [0]: https://github.com/snth/normconf2022/blob&#x2F
697.
by snthpy 4y ago
Composability is definitely a major design goal and I think we are getting close to that. Watch this space!
698.
by snthpy 4y ago
Thanks for the suggestion. I don't think I knew about usql. I completely agree with you and have been working on a cli tool called `prql-query` or `pq` at the command line: https://github.com/prql/prql-query/
699.
by snthpy 4y ago
What you are describing sounds like the `derive` transform in PRQL: it allows you to add new columns based on existing columns you already have. See [0]. Of course this is mostly also possible in SQL but PRQL makes this a bit nicer in that
700.
by snthpy 4y ago
Correct, s-strings are the general "escape hatch" to allow pass-through for things that are not yet implemented, like dialect specific functions. See the section in the PRQL Book [0] for more detail. It does make it opaque to the
701.
by snthpy 4y ago
PRQL is not aiming to be an ORM or data layer replacement and is focusing on a specific use case, viz making it simple and ergonomic to write *Analytical Queries*. See the the FAQ [0] for more on this. In most cases you want to be able to i
702.
by snthpy 4y ago
Kusto is one of the inspirations but there are many others like dplyr, LINQ, ... Have a look at the FAQ [0] for a more complete list. [0]: https://prql-lang.org/faq/#:~:text=Something%20here%20remind...
703.
by snthpy 4y ago
> Eg SELECT !username from users could expand to all columns without username. This should be landing in PRQL soon. See ongoing discussion here: [an exclude clause, that would select all columns except whats specified #172]( https:/
704.
by snthpy 4y ago
> As an example why would WHERE clauses need to have a AND instead of multiple WHERE clauses. PRQL does this: from employees filter country_code == "USA" # Each line transforms the previous result. filter age &g
705.
by snthpy 4y ago
Same here
706.
by snthpy 4y ago
That's definitely on the roadmap but we're not quite there yet. With the next release you will be able to create functions that are reusable pipeline segments (e.g. something like "top 5 items per group"). This works at
707.
by snthpy 4y ago
I don't recall us discussing that before. You can have named pipelines which basically become CTEs, like table employees_usa = (from employees | filter country=='USA') but ultimately there is usually just one "m
708.
by snthpy 4y ago
Full disclosure: I'm a PRQL contributor. There will be a big PRQL release in January which makes that previous discussion look quite dated. Best source for current state is the prql-lang.org website and the github repo (github.com&#x2F
709.
by snthpy 4y ago
Have a look at PRQL (www.prql-lang.org)!
710.
by snthpy 4y ago
There's my problem with nim. I was really excited about it two years ago and tried to get into it. Unfortunately I found the community not very welcoming. All the issues I had, had been raised before and dismissed. I've since swit
711.
by snthpy 4y ago
Does this help with getting kids to sleep at all?
712.
by snthpy 4y ago
If it was too hard for players in 1982 then there's no way today's players stand a chance.
713.
by snthpy 4y ago
Exactly this!
714.
by snthpy 4y ago
I don't know about beauty but I think in males there is a trade off like that between testosterone and the immune system.
715.
by snthpy 4y ago
What an awesome description. I hope I remember this if I'm ever in the area.
716.
by snthpy 4y ago
I've been curious about these kinds of services for a while. Genuine question: do you not end up just chatting with your paired partner?
717.
by snthpy 4y ago
This is a great point.
718.
by snthpy 4y ago
Same. I think it's weird, almost dishonest or shifty to have the camera off. In a big meeting ok, but with two or three people? Body language is part of communication and you can't just hide that. No wonder companies want to force
719.
by snthpy 4y ago
I'm sorry you had to go through that. Unfortunately I find it's not uncommon for anything that gets publicity. Let's call out bullies for sure and just stay strong in your belief in yourself that they only took notice because
720.
by snthpy 4y ago
Hello from sunny Cape Town, South Africa! I'm passionate about data and am excited about what's happening in the space with DBT, DuckDB and Apache Iceberg! I contribute to [PRQL](prq-lang.org) to make working with data even easier

More ›