So for that one, I wanted to return all the fields, but I wanted to apply a transformation to a couple of those fields and have it effectively replace them in-line. Does that makes sense?
@@learndatawithmark Sorry ... Felt most ware cosmetic... a bit of fluff.. However i later saw your PIVOT and UNPIVOT videos... and they were really excellent. Both in terms of DuckDb syntax /features and also your example/content. Thanks for the videos. New subscriber. cheers.
Ha sql is so basic already I am not feeling bad for the guy that has to have to type the word SELECT. Big boo hoo. Try to install a JavaScript package and not die of old age before you begin coding the project itself
Maybe the JavaScript package management system is such a pain because the developers suffered psychological damage from having to write SELECT first for all those years.
Thanks for the tips, just looking into DuckDB, nice to see these quality of life features.
Soo good Mark, love that they have the select last and group by all (which could be inferred) like in Cypher.
Thanks!
Thank you! Very kind
These are great, love DuckDB syntax.
Awesome video of very useful shortcuts, thanks Mark!
No worries!
One of my favorites (which you mentioned) is read_csv_auto() which includes the ability to read files from the internet.
That's definitely a cool one as well!
group by all I had no idea 🙏🙏🙏
They even added that feature to Snowflake now, so DuckDB is leading the charge!
could you explain again the REPLACE functionality and the use case in your precise example? I did't get it. Thanks
So for that one, I wanted to return all the fields, but I wanted to apply a transformation to a couple of those fields and have it effectively replace them in-line. Does that makes sense?
I'd give the features a ranking of 2,3,4,4,5 out of 10. cheers.
You are a tough one to please! 😄
@@learndatawithmark Sorry ... Felt most ware cosmetic... a bit of fluff.. However i later saw your PIVOT and UNPIVOT videos... and they were really excellent. Both in terms of DuckDb syntax /features and also your example/content. Thanks for the videos. New subscriber. cheers.
Ha sql is so basic already I am not feeling bad for the guy that has to have to type the word SELECT. Big boo hoo. Try to install a JavaScript package and not die of old age before you begin coding the project itself
Maybe the JavaScript package management system is such a pain because the developers suffered psychological damage from having to write SELECT first for all those years.