Add simple shell script functionality to urlencode examples

[ankoh]

Url-Encoding shell scripts would be very useful for issues and demos.

[davidgasquez]

Hey! Just curious if the following use case will be possible once this feature ships!

The idea is to publish a bunch of dbt compiled views queries somewhere. This is basically the result of export database 'database' (format parquet); for a database with only views for remote datasets.

Right now, these create statements could be copy-pasted but would be awesome if we could do something like load database github.com/user/repo/schema.sql and have the queries ready on any client (WASM, Python, ...)

Example of a compiled query

/* {"app": "dbt", "dbt_version": "1.0.4", "profile_name": "default", "target_name": "dev", "node_id": "model.datadex.energy_data"} */

create view "main"."energy_data" as (
  select
  iso_code,
  country,
  year,
  electricity_generation,
  biofuel_electricity,
  coal_electricity,
  fossil_electricity,
  gas_electricity,
  hydro_electricity,
  nuclear_electricity,
  oil_electricity,
  other_renewable_electricity,
  other_renewable_exc_biofuel_electricity,
  renewables_electricity,
  solar_electricity,
  wind_electricity,
  population,
  gdp
from 'https://nyc3.digitaloceanspaces.com/owid-public/data/energy/owid-energy-data.csv'
);

;
/* {"app": "dbt", "dbt_version": "1.0.4", "profile_name": "default", "target_name": "dev", "node_id": "model.datadex.energy_yearly_averages"} */

create view "main"."energy_yearly_averages" as (
  select
  year,
  avg(electricity_generation) as avg_electricity_generation,
  avg(biofuel_electricity) as avg_biofuel_electricity,
  avg(coal_electricity) as avg_coal_electricity,
  avg(fossil_electricity) as avg_fossil_electricity,
  avg(gas_electricity) as avg_gas_electricity,
  avg(hydro_electricity) as avg_hydro_electricity,
  avg(nuclear_electricity) as avg_nuclear_electricity,
  avg(oil_electricity) as avg_oil_electricity,
  avg(renewables_electricity) as avg_renewables_electricity,
  avg(solar_electricity) as avg_solar_electricity,
  avg(wind_electricity) as avg_wind_electricity,
  avg(energy_per_gdp) as avg_energy_per_gdp,
  avg(energy_per_capita) as avg_energy_per_capita
from 'https://nyc3.digitaloceanspaces.com/owid-public/data/energy/owid-energy-data.csv'
group by 1
);

;